Tag Archives: microsoft
Create Excel Chart with multiple series each with 2 data points
Hello,
I’m trying to create a chart in Excel with several straight lines composed with 2 data points each.
Each costumer has a sell date and sell value, and a purchase date and purchase value. Dates are in the X axis.
I just want that for each customer there is a straight line between sell and purchase value, on their respective dates, for each of the customers.
Is it possible?
I’ve attached an example file here.
Thanks in advance.
Hello, I’m trying to create a chart in Excel with several straight lines composed with 2 data points each. Each costumer has a sell date and sell value, and a purchase date and purchase value. Dates are in the X axis. I just want that for each customer there is a straight line between sell and purchase value, on their respective dates, for each of the customers. Is it possible? I’ve attached an example file here. Thanks in advance. Read More
Reduce Outlook mailbox size while keeping email messages and attachments (and access)
My work email is “Microsoft 365 Apps for business” account, and I’m getting a warning “Your mailbox is almost full”.
I’ve read I basically have four options:
Enable Online Archive.
Increase the mailbox size.
Move messages to a PST.
Third-party email archive solutions.
I would like to manually create a local PST backup. I found this page here: Archive items manually (Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Outlook 2016)
I completed the listed steps… now what? I don’t see any change in the Mailbox size. I didn’t see Outlook “do anything”.
My work email is “Microsoft 365 Apps for business” account, and I’m getting a warning “Your mailbox is almost full”. I’ve read I basically have four options: Enable Online Archive. Increase the mailbox size. Move messages to a PST.Third-party email archive solutions. I would like to manually create a local PST backup. I found this page here: Archive items manually (Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Outlook 2016) I completed the listed steps… now what? I don’t see any change in the Mailbox size. I didn’t see Outlook “do anything”. Read More
Intune scope tags
Hello All,
I am just playing around with my Intune test tenant and experiencing some issues on Scope tag.
Created scope tag 1 which is assigned to admin1 (role – can read and write compliance policies, read and delete devices) (No other roles assigned)
Created scope tag 2 not assigned to any admin
Created compliance policy and removed the default scope tag and added scope tag2. My issue is, still admin 1 was able to read and write this compliance policy. Why this is happening and Am I doing something wrong?
Hello All, I am just playing around with my Intune test tenant and experiencing some issues on Scope tag. Created scope tag 1 which is assigned to admin1 (role – can read and write compliance policies, read and delete devices) (No other roles assigned)Created scope tag 2 not assigned to any admin Created compliance policy and removed the default scope tag and added scope tag2. My issue is, still admin 1 was able to read and write this compliance policy. Why this is happening and Am I doing something wrong? Read More
i have proble applying for developer
i recently tried to apply for the microsoft developer program but microsoft blocks the application althought i put the correct info so is there anything i can do
i recently tried to apply for the microsoft developer program but microsoft blocks the application althought i put the correct info so is there anything i can do Read More
New Windows 11 Pro install won’t let me login via RDP
I have an existing Windows 10 Pro PC that I can remote desktop to from any other Windows PC without any issues.
I just built a new Windows 11 Pro PC and have enabled remote desktop and I can connect and get to a login but the login always fails no matter what I’ve tried.
Both PCs are on the same network. Both are logged with the same account and as far as I can tell, they are configured the same way, but the Windows 11 PC always says the login is incorrect.
What am I missing to get this working it’s pretty important that I can remove into my PC’s as I travel a lot and use them a lot remotely.
I have an existing Windows 10 Pro PC that I can remote desktop to from any other Windows PC without any issues.I just built a new Windows 11 Pro PC and have enabled remote desktop and I can connect and get to a login but the login always fails no matter what I’ve tried.Both PCs are on the same network. Both are logged with the same account and as far as I can tell, they are configured the same way, but the Windows 11 PC always says the login is incorrect.What am I missing to get this working it’s pretty important that I can remove into my PC’s as I travel a lot and use them a lot remotely. Read More
Maybe Complex! Dynamic Array Query
I have an input sheet with staff salaries – and starting dates etc to pull in monthly salary costs for forecasting. But also want a ‘profile’ to enable a user to input a revised amount (Usually upward) during the course of the next 2 years from the start of current year. These will be used to override the default amount on the calc sheet
Calc sheet has all the breakdowns of everything. But I am trying now to incorporate the profile from the Input sheet into my basic monthly salary amounts. Looking for something like this. Ignore the combining with default values as this is straightforward. But I need the array of override values as below
I thought this would be quite easy but it seems not. As the periods will change from monthly to 3 monthly, one needs to sum based on dates. I have the start and end of period at the top so can do that. But the array of periods on the calc sheet does not match that on the input sheet which will just allow for 2 years of overrides, after which, simple inflation will kick in. Can’t really forecast salary increases going out more than 2 year and for new starts the default value (not shown here) will be used with a starting date. So this will only be used for changes during the immediate forecast period.
A simple sumifs does actually work for a single row but I want to create a full 2D array.
=SUMIFS(Inputs!$N$72:$AJ$72,Inputs!$N$71#,”>=”&L3#,Inputs!$N$71#,”<“& L4#)
Tried sumproduct also and used MAP function to map the starting ending dates of the periods
=MAP(L3#,L4#,LAMBDA(x,y,SUMPRODUCT(Inputs!$N$72:$AJ$72,(Inputs!$N$71#>=x)*(Inputs!$N$71#<y))))
L3 has the array of period start dates and L4 has the period end dates (Calc sheet). $N72:$AJ$72 holds the range of salaries for the profile and N71 has the header dates for the profile (Inputs sheet). This works fine as does a simpler Sumifs without the need to MAP. BUT. If I change the range of $N72:$AJ$72 to contain more than one row, I get a calc error. So fine on a row by row but can’t get it all in a single 2D array.
I tried ByRow in conjunction but that fails. Seems I can’t combine ByRow with another lambda function say from MAP or such. I also tried using a Reduce with VSTACK. One problem I see is that the array of dates on the profile is not the same as that on the Calc sheet period start & end dates and I can’t see how to align these in a clever way. Its not as easy as just mapping as the profile dates will always be in months but the Calc sheet is dynamic and the current year and forecast years can be set to 1,3,6 or 12 months. I even tried creating a THUNK for one of the lambda functions. But always get the calc error Because only sumifs actually seems to work with 2 dynamic ranges of different sizes, but I can’t use an input array with Sumifs (only a range – but it also deoesnt seem to work with BYROW) and Sumproduct needs me to use a MAP function (or similar) to match the date criteria in one range (actually in 2) to the criteria range of the profile, I can’t see how to avoid double nested lambdas. I was surprised that the ByRow didn’t work as a wrapper around the map and sumproduct (Or sumifs)
Anyhow, I know there are so many super smart people out there, it is probably not that hard but for me, I’ve run out of options to try. I even considered a matrix multiplication but couldn’t get my head around that either!! I’m sure there is a solution using that.
PS. My attached sheet doesn’t use the same refs as described above. I put it together to illustrate the issues. Just took a camera pic and laid it roughly on top of the cells so that the refs – starting ones on some do actually reflect the above.
I have an input sheet with staff salaries – and starting dates etc to pull in monthly salary costs for forecasting. But also want a ‘profile’ to enable a user to input a revised amount (Usually upward) during the course of the next 2 years from the start of current year. These will be used to override the default amount on the calc sheetCalc sheet has all the breakdowns of everything. But I am trying now to incorporate the profile from the Input sheet into my basic monthly salary amounts. Looking for something like this. Ignore the combining with default values as this is straightforward. But I need the array of override values as belowI thought this would be quite easy but it seems not. As the periods will change from monthly to 3 monthly, one needs to sum based on dates. I have the start and end of period at the top so can do that. But the array of periods on the calc sheet does not match that on the input sheet which will just allow for 2 years of overrides, after which, simple inflation will kick in. Can’t really forecast salary increases going out more than 2 year and for new starts the default value (not shown here) will be used with a starting date. So this will only be used for changes during the immediate forecast period.A simple sumifs does actually work for a single row but I want to create a full 2D array.=SUMIFS(Inputs!$N$72:$AJ$72,Inputs!$N$71#,”>=”&L3#,Inputs!$N$71#,”<“& L4#)Tried sumproduct also and used MAP function to map the starting ending dates of the periods=MAP(L3#,L4#,LAMBDA(x,y,SUMPRODUCT(Inputs!$N$72:$AJ$72,(Inputs!$N$71#>=x)*(Inputs!$N$71#<y))))L3 has the array of period start dates and L4 has the period end dates (Calc sheet). $N72:$AJ$72 holds the range of salaries for the profile and N71 has the header dates for the profile (Inputs sheet). This works fine as does a simpler Sumifs without the need to MAP. BUT. If I change the range of $N72:$AJ$72 to contain more than one row, I get a calc error. So fine on a row by row but can’t get it all in a single 2D array. I tried ByRow in conjunction but that fails. Seems I can’t combine ByRow with another lambda function say from MAP or such. I also tried using a Reduce with VSTACK. One problem I see is that the array of dates on the profile is not the same as that on the Calc sheet period start & end dates and I can’t see how to align these in a clever way. Its not as easy as just mapping as the profile dates will always be in months but the Calc sheet is dynamic and the current year and forecast years can be set to 1,3,6 or 12 months. I even tried creating a THUNK for one of the lambda functions. But always get the calc error Because only sumifs actually seems to work with 2 dynamic ranges of different sizes, but I can’t use an input array with Sumifs (only a range – but it also deoesnt seem to work with BYROW) and Sumproduct needs me to use a MAP function (or similar) to match the date criteria in one range (actually in 2) to the criteria range of the profile, I can’t see how to avoid double nested lambdas. I was surprised that the ByRow didn’t work as a wrapper around the map and sumproduct (Or sumifs) Anyhow, I know there are so many super smart people out there, it is probably not that hard but for me, I’ve run out of options to try. I even considered a matrix multiplication but couldn’t get my head around that either!! I’m sure there is a solution using that. PS. My attached sheet doesn’t use the same refs as described above. I put it together to illustrate the issues. Just took a camera pic and laid it roughly on top of the cells so that the refs – starting ones on some do actually reflect the above. Read More
My region is India my funds will be credited to bank account how many days please request you sayin
My funds will be Indian bank account transfer to the bank account how many days please request you saying contact email Id.
My funds will be Indian bank account transfer to the bank account how many days please request you saying contact email Id. Read More
Another, hopefully quick, Dynamic Array question
With a 2D array I wanted to replace any blank values on a row with the previous value. I found this which sort of worked. =SCAN(0, N72:AJ74, LAMBDA(a,v, IF(v=””,a,v)))
However, the accumulator value is carried forward to the next row so if there is a value at the end of the previous row, it is carried forward to the next row as SCAN just works its way through the array. I want to treat each row independently so that there is nothing carried forward to the next row.
I tried with ByRow but this caused a calc error. Couldn’t find a way to ‘get’ the row number or to determine the row had changed and thus be able to set a to 0. Or, to get ByRow to work which would have been the easiest.
This could apply to the MAP function too as getting the row and column index could help determine a new column or row
With a 2D array I wanted to replace any blank values on a row with the previous value. I found this which sort of worked. =SCAN(0, N72:AJ74, LAMBDA(a,v, IF(v=””,a,v)))However, the accumulator value is carried forward to the next row so if there is a value at the end of the previous row, it is carried forward to the next row as SCAN just works its way through the array. I want to treat each row independently so that there is nothing carried forward to the next row.I tried with ByRow but this caused a calc error. Couldn’t find a way to ‘get’ the row number or to determine the row had changed and thus be able to set a to 0. Or, to get ByRow to work which would have been the easiest. This could apply to the MAP function too as getting the row and column index could help determine a new column or row Read More
Azure portal having issue with Latest Edge Beta Build.
Hi. So azure portal giving me errors in console when trying to create a resource. it just keep failing. already reported this issue via feedback, not sure it got fixed or not.
Azure working fine in firefox and Stable edge browser.
Hi. So azure portal giving me errors in console when trying to create a resource. it just keep failing. already reported this issue via feedback, not sure it got fixed or not. Azure working fine in firefox and Stable edge browser. Read More
Unable to add a calculated column in Microsoft Lists
Hi! I have tried finding the answer to this on my own, and am now turning to the community. I have started using Lists today, and I am looking to add a calculated column to calculate future dates. However, I am in the “preview” view and don’t have any option to add this type of column. This type of column simply does not exist in my options, and I also don’t have any column options in the settings view.
I have tried to see if there’s an upgrade I need, a different type of account, etc., but have found no guidance. The closest to an answer I received was that I might not have admin permissions, but I’m the only user of my own account.
Can you help me? Thank you!
Hi! I have tried finding the answer to this on my own, and am now turning to the community. I have started using Lists today, and I am looking to add a calculated column to calculate future dates. However, I am in the “preview” view and don’t have any option to add this type of column. This type of column simply does not exist in my options, and I also don’t have any column options in the settings view. I have tried to see if there’s an upgrade I need, a different type of account, etc., but have found no guidance. The closest to an answer I received was that I might not have admin permissions, but I’m the only user of my own account. Can you help me? Thank you! Read More
Adding assignee for subtasks in Microsoft To Do
Hi,
Will there be future plans for allowing to add assignee for subtasks in Microsoft To Do?
Hi, Will there be future plans for allowing to add assignee for subtasks in Microsoft To Do? Read More
How can I enter ABC in one text field and it should automatically write it in the second text field
How can I enter ABC in one text field and it should automatically write it in the second text field too.
How can I enter ABC in one text field and it should automatically write it in the second text field too. Read More
Conditional Access App Control keeps Bypassing
Hi all,
I’ve setup a Conditional Access policy in Entra ID with the following settings:
Targeted User: me (as a test)Targeted Resource: Office 365 (I’m interested specifically in SharePoint and OWA)Session Control: Use Conditional Access App Control > Custom Policy
I’ve then setup two policies in the Defender CAS service, one that prevents downloads and one that prevents Cut/Copy. I’ve not used the templates as I’d like to learn how to create these from scratch anyway.
The targets for both policies in CAS are simply App > Manual Onboarding > Microsoft Online Services. My understanding is that using “Microsoft Online Services” here should basically encompass all services I want. If I go to Settings in Defender Microsoft Exchange Online and Microsoft SharePoint both show as onboarded and enabled.
When I sign into one of these services, I can see it try and redirect me to the mcas.ms URL but then falls back to the original and the controls in my policies are not applied. If I check in the Activity Log my sign-ins show as “Bypass Session Control”.
Does anyone know what I might be missing?
TIA
Hi all, I’ve setup a Conditional Access policy in Entra ID with the following settings:Targeted User: me (as a test)Targeted Resource: Office 365 (I’m interested specifically in SharePoint and OWA)Session Control: Use Conditional Access App Control > Custom PolicyI’ve then setup two policies in the Defender CAS service, one that prevents downloads and one that prevents Cut/Copy. I’ve not used the templates as I’d like to learn how to create these from scratch anyway. The targets for both policies in CAS are simply App > Manual Onboarding > Microsoft Online Services. My understanding is that using “Microsoft Online Services” here should basically encompass all services I want. If I go to Settings in Defender Microsoft Exchange Online and Microsoft SharePoint both show as onboarded and enabled. When I sign into one of these services, I can see it try and redirect me to the mcas.ms URL but then falls back to the original and the controls in my policies are not applied. If I check in the Activity Log my sign-ins show as “Bypass Session Control”. Does anyone know what I might be missing? TIA Read More
#CONNECT! Error – Stockhistory down?
Is anyone else having this issue with stockhistory? I am receiving the #CONNECT! error randomly, sometimes it works, sometimes it doesn’t. I can change the time period, shorter or longer, and it just seems random when it decides to retrieve the data or not
Is anyone else having this issue with stockhistory? I am receiving the #CONNECT! error randomly, sometimes it works, sometimes it doesn’t. I can change the time period, shorter or longer, and it just seems random when it decides to retrieve the data or not Read More
How to get UserMeetingRole
Hi, we’ve got a tab app which needs to be able to find which of the users inside the meeting is the Organizer.
I see there is microsoftTeams.UserMeeringRole object with constants (Organizer, Attendee, etc).
However can’t find which API function returns this value?
This is essential because the organizer of the meeting needs to be able to access a few more actions and controls in the tab app.
Hi, we’ve got a tab app which needs to be able to find which of the users inside the meeting is the Organizer. I see there is microsoftTeams.UserMeeringRole object with constants (Organizer, Attendee, etc). However can’t find which API function returns this value? This is essential because the organizer of the meeting needs to be able to access a few more actions and controls in the tab app. Read More
VBA Code to Split Text
Hello,
My place of employee switched programs and there is currently not a way to extract data. I’m looking to insert a VBA code that splits the Job Title and Job Req # into seperate cells.
All job reqs start with a P. Here is a sample position/req.
Material HandlerP25-116021-2
Thank you!
Hello, My place of employee switched programs and there is currently not a way to extract data. I’m looking to insert a VBA code that splits the Job Title and Job Req # into seperate cells. All job reqs start with a P. Here is a sample position/req.Material HandlerP25-116021-2 Thank you! Read More
Uap16/17 BaseNamedObjectsIsolation
Some early feedback.
The latest Windows SDK includes a few new schema extensions. Documentation on these new extensions are not yet posted, and I assume that implementation is a work-in-progress and not released yet, but I am concerned that perhaps one of the items needs more thought before finalization.
Assuming that the new BasedNamedObjectsIsolation is an intended new feature to rename kernel named objects (like semaphores, mutexes, and other types) needed by software in the package, this would be a feature similar to that previously available via Microsoft App-V to help with running certain apps on multi-user operating systems or even multiple versions of the same app in parallel on a single user OS.
The schema for this element appears only to allow the specification to enable it for the package, and I am concerned that this is an insufficient level of control.
The equivalent feature in App-V included a system implemented (but registry editable) list of names to be excluded from the name spoofing. Furthermore, on a package basis the AppXManifest supported an override to include/exclude items.
The general system exclusion was a list of nearly 100 names. These exclusions were needed because the objects would also need to be recognized by name by an OS component that was not in the App-V container, so renaming one end would not work.
While Microsoft maintained this exclusion list (see HKEY_LOCAL_MACHINESOFTWAREMicrosoftAppVSubsystemObjExclusions) there was at least one time that IT Pros had to locally add to the exclusion list when Microsoft made a security change to RDS that broke almost half of App-V packages.
There was also a case where I helped a vendor with a package customization to the list because there were components in their package that ran outside of the App-V container (an out of process COM object) and needed to communicate using a name with a component running inside of the container.
Given that MSIX services might not be running inside the same container as the packaged app (I’m not sure about that) there might be more issues.
The bottom line is that there needs to be some exclusions applied somewhere, and overrides to the exclusion, at least on a system level, would be wise.
@Fiza_Azmi
Some early feedback.
The latest Windows SDK includes a few new schema extensions. Documentation on these new extensions are not yet posted, and I assume that implementation is a work-in-progress and not released yet, but I am concerned that perhaps one of the items needs more thought before finalization.
Assuming that the new BasedNamedObjectsIsolation is an intended new feature to rename kernel named objects (like semaphores, mutexes, and other types) needed by software in the package, this would be a feature similar to that previously available via Microsoft App-V to help with running certain apps on multi-user operating systems or even multiple versions of the same app in parallel on a single user OS.
The schema for this element appears only to allow the specification to enable it for the package, and I am concerned that this is an insufficient level of control.
The equivalent feature in App-V included a system implemented (but registry editable) list of names to be excluded from the name spoofing. Furthermore, on a package basis the AppXManifest supported an override to include/exclude items.
The general system exclusion was a list of nearly 100 names. These exclusions were needed because the objects would also need to be recognized by name by an OS component that was not in the App-V container, so renaming one end would not work.
While Microsoft maintained this exclusion list (see HKEY_LOCAL_MACHINESOFTWAREMicrosoftAppVSubsystemObjExclusions) there was at least one time that IT Pros had to locally add to the exclusion list when Microsoft made a security change to RDS that broke almost half of App-V packages.
There was also a case where I helped a vendor with a package customization to the list because there were components in their package that ran outside of the App-V container (an out of process COM object) and needed to communicate using a name with a component running inside of the container.
Given that MSIX services might not be running inside the same container as the packaged app (I’m not sure about that) there might be more issues.
The bottom line is that there needs to be some exclusions applied somewhere, and overrides to the exclusion, at least on a system level, would be wise. Read More
Add-Ons for Access 2019 (for PC)
Hello,
Today I search for some add-ons because there are none into my installed office 2019. So, I try it within Acces 2019 at settings, management. Oops… empty and nothing there to install.
Can anyone tell me how to get this add-ons into my system?
In previous Office (2007, 2009, 2013 and so on) they are installed at first installation.
Where or how can I get these COM and ACCESS add-ons???
By example: Analysis Toolpak, Analystis Toolpak – VBA, ASAP Utilities, Euro Currency Tools, Solution Add-Ons.
Thamks in advanced for your suggestions and help.
Hello,Today I search for some add-ons because there are none into my installed office 2019. So, I try it within Acces 2019 at settings, management. Oops… empty and nothing there to install.Can anyone tell me how to get this add-ons into my system?In previous Office (2007, 2009, 2013 and so on) they are installed at first installation.Where or how can I get these COM and ACCESS add-ons???By example: Analysis Toolpak, Analystis Toolpak – VBA, ASAP Utilities, Euro Currency Tools, Solution Add-Ons.Thamks in advanced for your suggestions and help. Read More
SQL and .net issue
Hi I am unable to see .mdf file in my visual studio when I opened one project of C# .Net in visual studio.
But same way the files are visible in data connections in YouTubers video.
I don’t have sql server installed and connected, is it happening due to this?
(I AM A BEGINNER PLS HELP IN THIS)
Hi I am unable to see .mdf file in my visual studio when I opened one project of C# .Net in visual studio.But same way the files are visible in data connections in YouTubers video. I don’t have sql server installed and connected, is it happening due to this? (I AM A BEGINNER PLS HELP IN THIS) Read More
Conditional Access Help
Hi –
Thought this would be easy but it’s not. We have a group of 5 temporary employees that need to access one custom built app in our environment. That app utilizes M365 authentication. I setup these users in a security group and want to block all access with the exclusion to this one app. The problem is, if I block Office 365, it does not allow them to login to the custom app. They get an error that blocks them, even though the app itself is excluded. I then exclude the app and Office 365 and it allows the login. This is frustrating because we cannot allow any access to Outlook, Sharepoint, OneDrive, etc. Any advice? When I try to search for just Exchange or Sharepoint by itself, there are no options to select under Cloud Apps.
Hi – Thought this would be easy but it’s not. We have a group of 5 temporary employees that need to access one custom built app in our environment. That app utilizes M365 authentication. I setup these users in a security group and want to block all access with the exclusion to this one app. The problem is, if I block Office 365, it does not allow them to login to the custom app. They get an error that blocks them, even though the app itself is excluded. I then exclude the app and Office 365 and it allows the login. This is frustrating because we cannot allow any access to Outlook, Sharepoint, OneDrive, etc. Any advice? When I try to search for just Exchange or Sharepoint by itself, there are no options to select under Cloud Apps. Read More