Tag Archives: microsoft
Prioritizing circular If statements?
When creating an amortization table in Excel I tried to place conditions on two of my columns using IF statements to return values based on other columns. When placing the second condition which involves the value of the cell of the first IF statement, I got a warning about a circular reference. This was fine as that’s what I needed it to do so I turned on allow multiple iterations. Now I get values returned but it completes the second IF statement before the first causing the first statement to return true when it should be returning false in turn messing up my numbers. I tried managing rules under conditional formatting but nothing showed up, I also tried rearranging my values to no avail. I believe my logic is sound and I would like to try and use this method, so I’m wondering is there a way to prioritize one IF statement over the other or will I need to find another way to achieve this.
When creating an amortization table in Excel I tried to place conditions on two of my columns using IF statements to return values based on other columns. When placing the second condition which involves the value of the cell of the first IF statement, I got a warning about a circular reference. This was fine as that’s what I needed it to do so I turned on allow multiple iterations. Now I get values returned but it completes the second IF statement before the first causing the first statement to return true when it should be returning false in turn messing up my numbers. I tried managing rules under conditional formatting but nothing showed up, I also tried rearranging my values to no avail. I believe my logic is sound and I would like to try and use this method, so I’m wondering is there a way to prioritize one IF statement over the other or will I need to find another way to achieve this. Read More
getpivotdata to fill out table
I am trying to use the numbers on the right as a key to get the value from the matching “Dinstinct Count of Rma Number” in the pivot table. I am not sure about how to use this function and the videos I have watched have not helped. I also want it to output a zero, but I should be able to do that with an isna()
Here are the pivot table fields if that helps.
Any help would be appreciated.
I am trying to use the numbers on the right as a key to get the value from the matching “Dinstinct Count of Rma Number” in the pivot table. I am not sure about how to use this function and the videos I have watched have not helped. I also want it to output a zero, but I should be able to do that with an isna()Here are the pivot table fields if that helps.Any help would be appreciated. Read More
Windows 11 blocks
Hello everybody. I have a very strange problem. Till yesterday my laptop with Windows 11 worked well but today all is blocking. I do not know if I give some command with the keyboard but suddenly I have a black screenshot. I shut PC off and then on but from this point on I can work only with CTRL key pressed down : if I leave this key a black screenshot reappear and my PC goes off. Restarting is quite normal but very soon black screenshot again and so on. I can work normally only if I press down the CTRL key. Maybe somethig goes wrong during power on ? Maybe the start configuration is corrupted ? May be my PC has some cruel hardware problem ? Could someone help me in solving this awful problem ?
Thank you in advace Jerry
Hello everybody. I have a very strange problem. Till yesterday my laptop with Windows 11 worked well but today all is blocking. I do not know if I give some command with the keyboard but suddenly I have a black screenshot. I shut PC off and then on but from this point on I can work only with CTRL key pressed down : if I leave this key a black screenshot reappear and my PC goes off. Restarting is quite normal but very soon black screenshot again and so on. I can work normally only if I press down the CTRL key. Maybe somethig goes wrong during power on ? Maybe the start configuration is corrupted ? May be my PC has some cruel hardware problem ? Could someone help me in solving this awful problem ?Thank you in advace Jerry Read More
Rule of thumb for number of champions
Wondering if anyone uses or knows of a heuristic for determining the ideal number of champions for Teams adoption or any other app. I assume number of users would be the denominator. Maybe nuances like use cases and scenarios for Teams use come into play. Would appreciate any thoughts on this.
Wondering if anyone uses or knows of a heuristic for determining the ideal number of champions for Teams adoption or any other app. I assume number of users would be the denominator. Maybe nuances like use cases and scenarios for Teams use come into play. Would appreciate any thoughts on this. Read More
MDO Attack Simulation and false “positives.”
In our last 3 attack simulations (MDO) we’ve sent out to employees, we’ve had increasingly more and more employees who are saying they didn’t open the attachment and/or didn’t click on the link. (They received the training email and asked “why” they received it…….)
Is there a way to prove/disprove they did or did not?
I’ve checked the settings on our simulations and they have been configured correctly. I don’t want to point “blame” on any of our “compromised” users as now I’m uncertain as to whether or not they were truly compromised. Is there something I’m missing here? Thanks everyone
In our last 3 attack simulations (MDO) we’ve sent out to employees, we’ve had increasingly more and more employees who are saying they didn’t open the attachment and/or didn’t click on the link. (They received the training email and asked “why” they received it…….)Is there a way to prove/disprove they did or did not? I’ve checked the settings on our simulations and they have been configured correctly. I don’t want to point “blame” on any of our “compromised” users as now I’m uncertain as to whether or not they were truly compromised. Is there something I’m missing here? Thanks everyone Read More
How Can I Migrate My Data to Quick-Books Smoothly and Without Losing Information?
I’m looking to migrate all my financial data to Quick-Books. What are the best practices and steps involved in Q.B Data Migration Services to ensure a smooth and complete data migration without losing any information or experiencing significant downtime?
I’m looking to migrate all my financial data to Quick-Books. What are the best practices and steps involved in Q.B Data Migration Services to ensure a smooth and complete data migration without losing any information or experiencing significant downtime? Read More
New Desktop Outlook
I just recently started using the new Outlook desktop version. New mail notifications are no longer showing in the corner of my screen. I have turned off focus, I doubled checked new mail notification is turned on, but I still do not receive notification. I do not want sound notification due to small office setting. The new settings are completely different and I have tried everything to get the mail icon to show up. Any help would be appreciated.
I just recently started using the new Outlook desktop version. New mail notifications are no longer showing in the corner of my screen. I have turned off focus, I doubled checked new mail notification is turned on, but I still do not receive notification. I do not want sound notification due to small office setting. The new settings are completely different and I have tried everything to get the mail icon to show up. Any help would be appreciated. Read More
Number of overdue to-do’s in app icon is wrong
Hi
I am using To Do on iOS devices connected to a company account. The setting for the count in the app badge is “due today and overdue”. The number is always one too high, i.e. even when I have no due/overdue task or mail, it shows “1”. There seems to be as “ghost” task or mail somewhere, how can I find it?
HiI am using To Do on iOS devices connected to a company account. The setting for the count in the app badge is “due today and overdue”. The number is always one too high, i.e. even when I have no due/overdue task or mail, it shows “1”. There seems to be as “ghost” task or mail somewhere, how can I find it? Read More
How to fix Employees cannot sign into Workforce error after update?
Employees are unable to sign into the Workforce portal, encountering authentication errors despite correct credentials.
Employees are unable to sign into the Workforce portal, encountering authentication errors despite correct credentials. Read More
Why Employees Unable to Access Paystubs on Windows 10
Several of our employees using Windows 10 are encountering difficulties accessing their paystubs through our system. Previously, they could easily view and download their pay information, but now they’re seeing error messages or unable to find their paystubs altogether. We’ve checked their permissions and tried troubleshooting steps on their Windows 10 computers, but the issue persists. What could be causing this problem specifically on Windows 10, and what steps can we take to resolve it?
Several of our employees using Windows 10 are encountering difficulties accessing their paystubs through our system. Previously, they could easily view and download their pay information, but now they’re seeing error messages or unable to find their paystubs altogether. We’ve checked their permissions and tried troubleshooting steps on their Windows 10 computers, but the issue persists. What could be causing this problem specifically on Windows 10, and what steps can we take to resolve it? Read More
How to fix Unable to log into WorkForce error after update?
I’m encountering difficulties logging into WorkForce. Despite entering correct credentials, access is denied repeatedly.
I’m encountering difficulties logging into WorkForce. Despite entering correct credentials, access is denied repeatedly. Read More
How to fix Employer cannot log into Workforce error after update?
An employer encounters difficulty logging into the workforce management system despite multiple attempts. Error message prompts “Invalid credentials” even after password reset. Seeking community help to resolve access issue swiftly.
An employer encounters difficulty logging into the workforce management system despite multiple attempts. Error message prompts “Invalid credentials” even after password reset. Seeking community help to resolve access issue swiftly. Read More
Heading Text in Excel
Why doesn’t an Ampersand show in a heading text?
Why doesn’t an Ampersand show in a heading text? Read More
You have to delete all the items in this folder before you delete the folder
This is new.
I can select one folder with several subfolders and delete it.
I can select several folders with no subfolders and delete them.
I can no longer select more than one folder with subfolders to delete them.
I get this error: You have to delete all the items in this folder before you delete the folder
This is new. I can select one folder with several subfolders and delete it. I can select several folders with no subfolders and delete them. I can no longer select more than one folder with subfolders to delete them. I get this error: You have to delete all the items in this folder before you delete the folder Read More
Export Planner Premium (PWA) to be reimported in MS project desktop app
Hi,
While trying to export a project from the Project Web App (as part of the Planner Premium), one would expect some backwards compatibility with MS project desktop app (legacy software…). One must export to Excel first to be able to import the excel file into MS project desktop app. But this does not work at all… many, many tweaks and modifications of the Excel sheet (tab names, field names, outline level numbering, etc) are necessary to hope some sort of “clean” import.
Considering the many limitation that PWA exhibits, a scenario where user hits limitations and want to migrate to full featured desktop app sounds reasonable and desirable. Migration should be native.
Best
Hi,While trying to export a project from the Project Web App (as part of the Planner Premium), one would expect some backwards compatibility with MS project desktop app (legacy software…). One must export to Excel first to be able to import the excel file into MS project desktop app. But this does not work at all… many, many tweaks and modifications of the Excel sheet (tab names, field names, outline level numbering, etc) are necessary to hope some sort of “clean” import.Considering the many limitation that PWA exhibits, a scenario where user hits limitations and want to migrate to full featured desktop app sounds reasonable and desirable. Migration should be native.Best Read More
What is error code OLSU 1013 in Quick-Books Desktop and how can I resolve this issue?
I keep encountering the error code OLSU 1013 in Quick-Books while trying to connect my bank account. It says there’s an issue with my financial institution. Can you help me troubleshoot this problem?
I keep encountering the error code OLSU 1013 in Quick-Books while trying to connect my bank account. It says there’s an issue with my financial institution. Can you help me troubleshoot this problem? Read More
Exclude folder underneath Documents by policy
Hello my dear friends,
I like to know if there is a way (intune, SCCM oder ADMX template) to exclude a subfolder of syncronized folder (Known folder move) named “Documents“. The reason is, that there is a software deployed automatically to the computers and this software stores a lot of files with a lot of changes over the day to this folder underneath Documents and OneDrive is starting to hang oder starting to throw sync errors because of that. Now we need to exclude this folder for sync.
Any help is appreciated
PS: To install the software on hundrets of clients to another directory unfortunately is not an option, to get ahead of you 😉 😉
Hello my dear friends, I like to know if there is a way (intune, SCCM oder ADMX template) to exclude a subfolder of syncronized folder (Known folder move) named “Documents”. The reason is, that there is a software deployed automatically to the computers and this software stores a lot of files with a lot of changes over the day to this folder underneath Documents and OneDrive is starting to hang oder starting to throw sync errors because of that. Now we need to exclude this folder for sync. Any help is appreciatedPS: To install the software on hundrets of clients to another directory unfortunately is not an option, to get ahead of you 😉 😉 Read More
SIGILL coredump and Linux builds debug symbols
Hello everyone,
Is there any plan to not stripping debug symbols (or offering them in a package) for Beta/Dev builds of Edge on Linux or offering them as a package?
And if not, why? I get stripping them for space efficiency, but usually there’d be a microsoft-edge-beta-debugsym/devel package with it for such cases.
This is prompted by getting a SIGILL tab worker crash every now and then (Edge Beta channel on Fedora), and would like to investigate, but I’m unable to do much with the backtrace I get back since it is all mangled.
It’s not super frequent, but I got ~100 of these over the past year, and it would be helpful for us (and for Microsoft in turn) if we could help look into what is happening.
I suspect the issue lies with hardware-accelerated DOM rendering (since nearly all Linux browser issues seem to originate in the sad history of Nvidia GPUs on it), but I’d like some conclusive proof or to be able to get the bug looked into at some point.
Thanks
Hello everyone, Is there any plan to not stripping debug symbols (or offering them in a package) for Beta/Dev builds of Edge on Linux or offering them as a package?And if not, why? I get stripping them for space efficiency, but usually there’d be a microsoft-edge-beta-debugsym/devel package with it for such cases. This is prompted by getting a SIGILL tab worker crash every now and then (Edge Beta channel on Fedora), and would like to investigate, but I’m unable to do much with the backtrace I get back since it is all mangled. It’s not super frequent, but I got ~100 of these over the past year, and it would be helpful for us (and for Microsoft in turn) if we could help look into what is happening. I suspect the issue lies with hardware-accelerated DOM rendering (since nearly all Linux browser issues seem to originate in the sad history of Nvidia GPUs on it), but I’d like some conclusive proof or to be able to get the bug looked into at some point. Thanks Read More
How can I resolve Quick-Books Error OLSU 1024 when connecting to my bank?
I’m encountering Quick-Books Error OLSU 1024 when trying to connect my bank account. It says there’s an issue with my bank’s website or my Internet connection, but both seem to be working fine. Can you provide troubleshooting steps to resolve this issue?
I’m encountering Quick-Books Error OLSU 1024 when trying to connect my bank account. It says there’s an issue with my bank’s website or my Internet connection, but both seem to be working fine. Can you provide troubleshooting steps to resolve this issue? Read More
Return value from whichever cell contains a value based on two cells
Hi,
Only one cell from colE or colF will contain a value
What formula will I use to return a result in colG
Example
e8=”” f8=”pink” g8=”pink”
e9=”red” f9=”” g9=”red”
The result returned in colG is pink and red
Thankyou for your interest.
Hi, Only one cell from colE or colF will contain a value What formula will I use to return a result in colG Examplee8=”” f8=”pink” g8=”pink”e9=”red” f9=”” g9=”red” The result returned in colG is pink and red Thankyou for your interest. Read More