Tag Archives: microsoft
What To Do When stuck in QuickBooks Desktop Payroll Update Not Working after latest update?
I’m having trouble with my QuickBooks Desktop Payroll update not working. How can I fix this issue?
I’m having trouble with my QuickBooks Desktop Payroll update not working. How can I fix this issue? Read More
Looking to confirm effects of “Sign out inactive users” setting in Sharepoint admin center
Hi. I’m a MS global admin for my company (and quite new to it). Our security center is recommending enabling “Idle session sign-out” in the Sharepoint admin center (setting here, documentation here)
The documentation says the article is for “admins wanting to control user access to SharePoint and OneDrive (business) data on unmanaged devices”. What about Windows devices that are managed in Intune, does it not affect them? (we only allow Intune-managed company-purchased computers to access 365 resources)
Before I enable it, I want to confirm this setting only applies to the web-app/browser versions Sharepoint and OneDrive, that it doesn’t cause the desktop version of OneDrive to sign out. Also, if someone is using the browser version of OneDrive and it does sign out, will it affect other people accessing shared files in said OneDrive?
Hi. I’m a MS global admin for my company (and quite new to it). Our security center is recommending enabling “Idle session sign-out” in the Sharepoint admin center (setting here, documentation here) The documentation says the article is for “admins wanting to control user access to SharePoint and OneDrive (business) data on unmanaged devices”. What about Windows devices that are managed in Intune, does it not affect them? (we only allow Intune-managed company-purchased computers to access 365 resources) Before I enable it, I want to confirm this setting only applies to the web-app/browser versions Sharepoint and OneDrive, that it doesn’t cause the desktop version of OneDrive to sign out. Also, if someone is using the browser version of OneDrive and it does sign out, will it affect other people accessing shared files in said OneDrive? Read More
Bluetooth supposedly connected my “Beats Audio” ear bugs/my Bose AE 2 headphones! NOT = ! = WTH
Bluetooth supposedly connected my “Beats Audio” ear bugs/my “Bose AE-2 Soundlink” headphones! NOT happening, I have to connect via System–>Bluetooth, it may take more than two (2), I say again, 2 attempts.
Unsatisfactory, link to laptop should have occurred w/o my having to do it, via the System menu!
I have had both of my Bluetooth ‘items’ connect before (devices are found & listed), now I don’t trust the system to connect… Is this the 21st century, or what the $#@* is the matter?!!
Whose testing this ‘SNAP’?!!
Bluetooth supposedly connected my “Beats Audio” ear bugs/my “Bose AE-2 Soundlink” headphones! NOT happening, I have to connect via System–>Bluetooth, it may take more than two (2), I say again, 2 attempts. Unsatisfactory, link to laptop should have occurred w/o my having to do it, via the System menu!I have had both of my Bluetooth ‘items’ connect before (devices are found & listed), now I don’t trust the system to connect… Is this the 21st century, or what the $#@* is the matter?!! Whose testing this ‘SNAP’?!! Read More
Inventory Management in Sharepoint
Hi there,
I have an inventory list for our first aid kit in SharePoint lists.
The list keeps track of:
– the items we have
– how many we have
– when to reorder them
– when they expire
– when they were last checked
– who checked them.
I am wanting to create a form or list for the incident reports which will include the incident that happened and what they used. I want to somehow CONNECT these so that we can see the history of these items.
For example:
For plasters we can see :
Joe used x2 plasters on 12/12/2012
Anne used x1 plaster on. 01/01/2013
Etc.
I’m not sure how to go about this? Any ideas?
Thanks
Hi there,I have an inventory list for our first aid kit in SharePoint lists.The list keeps track of:- the items we have- how many we have- when to reorder them- when they expire- when they were last checked- who checked them. I am wanting to create a form or list for the incident reports which will include the incident that happened and what they used. I want to somehow CONNECT these so that we can see the history of these items.For example:For plasters we can see :Joe used x2 plasters on 12/12/2012Anne used x1 plaster on. 01/01/2013Etc. I’m not sure how to go about this? Any ideas?Thanks Read More
Microsoft Teams Calling blocked “We couldn’t complete the call. Please contact your admin”
On a relatively new (3 weeks old) tenant, set up cleanly, with paid subscriptions and proper, correct licensing for Teams Calling, PSTN calling has been working fine since implementation.
But last night I received multiple emails stating “Skype for Business all users blocked for PSTN calling – We have detected what may be fraudulent calling activity for one or more of your Skype for Business users. In order to prevent financial risk to you and your business we have disabled calling and/or conferencing services for all users:”
I got an email for each user, AND an email stating that ALL users were blocked.
This is a brand new tenant in Teams-only mode, SkypeForBusiness doesn’t even show up in the tenant. There is no “Reports->Skype for Business->ANYTHING” option in the M365 Admin Center.
Entra Admin Center shows no logins or unknown activity for any of the users (all of which are protected with 2FA and authenticators). The Teams Admin Center Usage Report shows only two calls made in the past 24 hours – both were test calls from me to my cell testing out call forwarding. The Teams Admin Center Blocked Users Report is broken and crashing.
I tried to test with the self-help diagnostics. Interestingly, the diagnostic fails saying there is no number assigned to the user…
Except that there is. In the assigned numbers screen, everything shows up properly and correctly.
The emails state: “If you determine the call(s) were not fraudulent, please: Contact Microsoft Support. A customer support agent will assist you in unblocking the user’s calling and/or conferencing capabilities.”
The problem is that the support engineers I’m getting are on the other side of the planet, with an accent very different than mine. They can barely understand me and I can barely hear them. Worse: they kept attempting to debug using Get-CsUser – which is a fully-deprecated and no-longer-working cmdlet, and then basically gave up, saying they would “escalate it to their back office.” They have no idea what is happening or why or how to fix it.
I’ve had no updates since.
Does anyone know why this happened or how to fix it? No fraudulent logins, no compromised accounts, no strange calls, no nothing… and yet the entire tenant is blocked? I’ve gone through most of the PowerShell cmdlets I can think of, compared them against a working tenant, and they’re all identical – yet both incoming and outgoing PSTN calling remains blocked.
Can anyone help me either fix this, or teach me how to get past the very difficult-to-work-with front-line support at Microsoft to someone who knows how to unblock this?
My users are already looking at Google Voice… ugh…
On a relatively new (3 weeks old) tenant, set up cleanly, with paid subscriptions and proper, correct licensing for Teams Calling, PSTN calling has been working fine since implementation. But last night I received multiple emails stating “Skype for Business all users blocked for PSTN calling – We have detected what may be fraudulent calling activity for one or more of your Skype for Business users. In order to prevent financial risk to you and your business we have disabled calling and/or conferencing services for all users:” I got an email for each user, AND an email stating that ALL users were blocked. This is a brand new tenant in Teams-only mode, SkypeForBusiness doesn’t even show up in the tenant. There is no “Reports->Skype for Business->ANYTHING” option in the M365 Admin Center. Entra Admin Center shows no logins or unknown activity for any of the users (all of which are protected with 2FA and authenticators). The Teams Admin Center Usage Report shows only two calls made in the past 24 hours – both were test calls from me to my cell testing out call forwarding. The Teams Admin Center Blocked Users Report is broken and crashing. I tried to test with the self-help diagnostics. Interestingly, the diagnostic fails saying there is no number assigned to the user… Except that there is. In the assigned numbers screen, everything shows up properly and correctly. The emails state: “If you determine the call(s) were not fraudulent, please: Contact Microsoft Support. A customer support agent will assist you in unblocking the user’s calling and/or conferencing capabilities.” The problem is that the support engineers I’m getting are on the other side of the planet, with an accent very different than mine. They can barely understand me and I can barely hear them. Worse: they kept attempting to debug using Get-CsUser – which is a fully-deprecated and no-longer-working cmdlet, and then basically gave up, saying they would “escalate it to their back office.” They have no idea what is happening or why or how to fix it. I’ve had no updates since. Does anyone know why this happened or how to fix it? No fraudulent logins, no compromised accounts, no strange calls, no nothing… and yet the entire tenant is blocked? I’ve gone through most of the PowerShell cmdlets I can think of, compared them against a working tenant, and they’re all identical – yet both incoming and outgoing PSTN calling remains blocked. Can anyone help me either fix this, or teach me how to get past the very difficult-to-work-with front-line support at Microsoft to someone who knows how to unblock this? My users are already looking at Google Voice… ugh… Read More
“Go to connections” in appearing in SharePoint Online Home Site
Hi,
Recently, I have observed in some tenant “Go to connections” button is appearing in SharePoint Online Home communication site. Is it possible to disable this option from SharePoint end ?
Also, is there any documentation around this when Microsoft released this feature and what is this ?
Thank you in advance for your response on this topic.
Regards,
Pratik
Hi, Recently, I have observed in some tenant “Go to connections” button is appearing in SharePoint Online Home communication site. Is it possible to disable this option from SharePoint end ? Also, is there any documentation around this when Microsoft released this feature and what is this ? Thank you in advance for your response on this topic. Regards,Pratik Read More
What are some effective methods and tools available for recovering corrupted or lost PST files?
You can recover your data with Softaken Outlook PST Repair Software. Recover your PST file with this simple tool. This powerful tool is designed to restore your damaged or corrupted PST file quickly and efficiently. Users can recover mailboxes, calendars, contacts, messages, attachments, tasks, and much more from Outlook PST files with these features. Its scanning technology ensures complete data recovery without any loss. Perfect for both personal and business purposes, this software is a great solution for PST file recovery.
You can recover your data with Softaken Outlook PST Repair Software. Recover your PST file with this simple tool. This powerful tool is designed to restore your damaged or corrupted PST file quickly and efficiently. Users can recover mailboxes, calendars, contacts, messages, attachments, tasks, and much more from Outlook PST files with these features. Its scanning technology ensures complete data recovery without any loss. Perfect for both personal and business purposes, this software is a great solution for PST file recovery. Read More
Format X-Axis label colors in Excel charts
Dear Experts,
May be a trivial case, but how would you change the X-axis label colors/Font?
If they are numbers we can play around, but if they are Text , I couldn’t see such option.
For example, in below chart, I want to color the “BWP_CHNG_FAIL” and “PARSING_NOT_ENABLED” as Bold-RED, while “NO_ERROR” as Bold Green, how would I achieve that?
In Format Axis, not much option , I can see for that to color based on different criteria?
Attaching the Sample file,
Thanks in Advance,
Br,
Anupam
Dear Experts, May be a trivial case, but how would you change the X-axis label colors/Font?If they are numbers we can play around, but if they are Text , I couldn’t see such option.For example, in below chart, I want to color the “BWP_CHNG_FAIL” and “PARSING_NOT_ENABLED” as Bold-RED, while “NO_ERROR” as Bold Green, how would I achieve that?In Format Axis, not much option , I can see for that to color based on different criteria?Attaching the Sample file,Thanks in Advance,Br,Anupam Read More
Text wrapping in a table
The text has stopped wrapping at the end of the line. It was okay but I must have done something to mess it up. It’s as if it’s hidden under the next column. Help!
The text has stopped wrapping at the end of the line. It was okay but I must have done something to mess it up. It’s as if it’s hidden under the next column. Help! Read More
How can I fix a payroll error in QuickBooks Desktop?
I’m encountering a payroll error in QuickBooks Desktop that’s causing issues with processing payroll. Can you provide guidance on how to troubleshoot and resolve this problem efficiently?
I’m encountering a payroll error in QuickBooks Desktop that’s causing issues with processing payroll. Can you provide guidance on how to troubleshoot and resolve this problem efficiently? Read More
What are your top blockers with customers?
In this age of just trying to keep up with the rapid pace of innovations, the smallest stumbling blocks can make a mountain out of a mole hill. What are your top blockers with your customers? Licensing? Regulations? Inadequate funds? Time constraints? Not enough resources? Lack of training?
Tell us your top blockers and more importantly how you have overcome them. Share your successes and share what didn’t work. We all learn from our failures and it leads to a path of success.
In this age of just trying to keep up with the rapid pace of innovations, the smallest stumbling blocks can make a mountain out of a mole hill. What are your top blockers with your customers? Licensing? Regulations? Inadequate funds? Time constraints? Not enough resources? Lack of training? Tell us your top blockers and more importantly how you have overcome them. Share your successes and share what didn’t work. We all learn from our failures and it leads to a path of success. Read More
What’s New in Excel (May 2024)
Welcome to the May 2024 update. This month, filtering for comments is rolling out to Excel for the web, and the new regular expression (REGEX) functions are rolling out to Insider Beta for Excel for Windows & Mac.
Excel for Web:
Filtering for Comments #FIA
Excel for Windows & Mac:
New Regular Expression (REGEX) Functions (Insiders)
Excel for Web
#FIA
Filtering for Comments
You can now filter comments that are active, resolved, or ones that @mention you so that you can find the comments you’re looking for. Filtering to a certain set of comments will update which comment indicators you see on the worksheet so you can focus on which comments are important with the context of your work. This feature is already supported on Mac and is currently rolling out to Web users.
Excel for Windows & Mac
New Regular Expression (REGEX) Functions (Insiders)
Regular expressions, or “regex,” are sequences of characters that define search patterns, commonly used for string searching and text parsing. They are incredibly versatile and are often used to check if a string contains a certain pattern, extract substrings that match the pattern, or replace substrings that match the pattern.
The new regex functions we are introducing are:
REGEXTEST: Checks if any part of supplied text matches a regex pattern.
REGEXEXTRACT: Extracts one or more parts of supplied text that match a regex pattern.
REGEXREPLACE: Searches for a regex pattern within supplied text and replaces it with different text.
We’re excited that these new functions can help you parse text more easily. Read more here >
Check if a specific feature is in your version of Excel
Click here to open in a new browser tab
Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—“Give a compliment” or “Make a suggestion”.. You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.
Special thanks to our Excel MVPs David Benaim, Bill Jelen, and Alan Murray for their contribution to this month’s What’s New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel. Alan is an Excel trainer, author and speaker, best known for his blog Computergaga.com and YouTube channel with the same name.
Microsoft Tech Community – Latest Blogs –Read More
Excel Labs
Hello Team,
Does this add-in send prompts entered by the user on Excel directly to OpenAI?
Hello Team,Does this add-in send prompts entered by the user on Excel directly to OpenAI? Read More
learning Java script and growing the skills for a tech job
Hi, I’m a data consultant and I’ve been working with some light coding and really enjoy and wanting to find the best way to start learning more coding weather it be YouTube course or some coding classes. If anyone has some suggestions
Hi, I’m a data consultant and I’ve been working with some light coding and really enjoy and wanting to find the best way to start learning more coding weather it be YouTube course or some coding classes. If anyone has some suggestions Read More
Entering Data from another sheet
Hello ,
I am creating a new excel sheet from scratch as my old program FileMaker Pro isn’t compatible anymore. I used to be able to have a template on there, and it would pull data for each student individually from another source.
I need to somehow recreate this in excel, and pull data into my template that includes students names, DOB, and classroom name.
Is it possible to set this up so data for each student pulls into my template and as I scroll it switches to a different student and their info?
I currently have all my data pulled.
Does the data all need to be on one line combined in one cell or can everything have its own cell then pull into the template into a certain cell for each student? So essentially it all pulls together and as I scroll it switches students and their info.
thanks so much. I know this is a big ask!
Hello , I am creating a new excel sheet from scratch as my old program FileMaker Pro isn’t compatible anymore. I used to be able to have a template on there, and it would pull data for each student individually from another source. I need to somehow recreate this in excel, and pull data into my template that includes students names, DOB, and classroom name. Is it possible to set this up so data for each student pulls into my template and as I scroll it switches to a different student and their info? I currently have all my data pulled.Does the data all need to be on one line combined in one cell or can everything have its own cell then pull into the template into a certain cell for each student? So essentially it all pulls together and as I scroll it switches students and their info.thanks so much. I know this is a big ask! Read More
Timesheet Help – Adding potential unpaid break
Hi all,
I’m trying to create a timesheet that calculates my hours while subtracting a potential unpaid break. Currently, what I have is =IFERROR(MOD(([@[Time Out]]-[@[Time In]])-([@[Unpaid Time End]]-[@[Unpaid Time Start]]),1)*24,0). This works, but only if values are inputted under the unpaid times. This is great if I do have an unpaid break. But what if I don’t take a break? I’d have to enter the exact same time under unpaid time in and unpaid time end (e.g., 2:00pm – 2:00pm), or else the hours worked for that day will stay 0.
How do I rewrite the formula so that Unpaid Time Start/End is only calculated if time values are inputted? I really appreciate any help.
Hi all, I’m trying to create a timesheet that calculates my hours while subtracting a potential unpaid break. Currently, what I have is =IFERROR(MOD(([@[Time Out]]-[@[Time In]])-([@[Unpaid Time End]]-[@[Unpaid Time Start]]),1)*24,0). This works, but only if values are inputted under the unpaid times. This is great if I do have an unpaid break. But what if I don’t take a break? I’d have to enter the exact same time under unpaid time in and unpaid time end (e.g., 2:00pm – 2:00pm), or else the hours worked for that day will stay 0. How do I rewrite the formula so that Unpaid Time Start/End is only calculated if time values are inputted? I really appreciate any help. Read More
New List Experience – Turn Off Pop up window
Hello everyone,
We have the new SharePoint list experience and honestly, we hate it so much!
It is so buggy and we want to roll back.
1. When we click on new item or open an item, it opens up in a teeny tiny pop-up. Is there any way to revert to the full screen that opens from the right? We had a great three-column set up and now the form opens in a tiny window in a single column.
2. When we click on the column name to filter/sort or edit, it keeps throwing an error “Could not find tow selection cell or item key header” and have to refresh the page to access the list again.
3. Layout and formatting have gone haywire and all the align and padding conditional formatting done through column JSON formatting are no longer consistent across devices.
Why does Microsoft shove such a buggy awful product down our throats with no rollback option? This is something we should opt in for experiments and definitely not ready for production tenants.
We absolutely hate this!
Hello everyone, We have the new SharePoint list experience and honestly, we hate it so much! It is so buggy and we want to roll back. 1. When we click on new item or open an item, it opens up in a teeny tiny pop-up. Is there any way to revert to the full screen that opens from the right? We had a great three-column set up and now the form opens in a tiny window in a single column. 2. When we click on the column name to filter/sort or edit, it keeps throwing an error “Could not find tow selection cell or item key header” and have to refresh the page to access the list again. 3. Layout and formatting have gone haywire and all the align and padding conditional formatting done through column JSON formatting are no longer consistent across devices. Why does Microsoft shove such a buggy awful product down our throats with no rollback option? This is something we should opt in for experiments and definitely not ready for production tenants. We absolutely hate this! Read More
Add a new customer to a list of customers in a table
I use a sheet just for gathering customer information for new customers. I use this to feed information to sheets that generate bids for the 4 services I offer. Cells B3-B7 are Named Cells.
I’d like to copy this information (above) to a list of customers in a table on a separate sheet (below). This way, when I work for a customer on future jobs and do the exact same job I can run a macro to copy information from the table back to the cells in the screenshot above. From here I can quickly generate a bid for my services at current prices, and I don’t have to worry about typing in the wrong information.
So my question is: how do I copy Nicole’s information to row 6, the next customer’s information to rows7, etc with a macro?
I use a sheet just for gathering customer information for new customers. I use this to feed information to sheets that generate bids for the 4 services I offer. Cells B3-B7 are Named Cells. I’d like to copy this information (above) to a list of customers in a table on a separate sheet (below). This way, when I work for a customer on future jobs and do the exact same job I can run a macro to copy information from the table back to the cells in the screenshot above. From here I can quickly generate a bid for my services at current prices, and I don’t have to worry about typing in the wrong information. So my question is: how do I copy Nicole’s information to row 6, the next customer’s information to rows7, etc with a macro? Read More
Excel Help
I have an excel file with emp id, name, designation, department, date, ot hours and normal hours as columns.
Here are some sample data
111,John,Manager,HR,01/01/2024,0,9
111,John,Manager,HR,01/03/2024,3,0
111,John,Manager,HR,01/04/2024,2,9
222,Rogr,Supervr,MM,01/01/2024,0,9
222,Rogr,Supervr,MM,01/02/2024,0,9
333,Sand,PSWABCs,NG,01/15/2024,0,9
333,Sand,PSWABCs,NG,01/16/2024,0,9
333,Sand,PSWABCs,NG,01/17/2024,0,9
333,Sand,PSWABCs,NG,01/19/2024,0,9
333,Sand,PSWABCs,NG,01/25/2024,4,9
My requirement is show emp id, name, designation, department, type and convert the date into column and show the ot and normal hours. Type column should show the hour type (OT or Normal)
If the employee got both ot and normal, there should be 2 rows. Row 1 normal hours and Row 2 OT hours.
Also, if for the month a date is missing, I still need to see that as a header column and show 0 for both OT and normal.
With the above sample data, I am looking for the following results for employee 111
111,John,Manager,HR,01/01/2024,OT,0
111,John,Manager,HR,01/01/2024,Normal,9
111,John,Manager,HR,01/03/2024,OT,3
111,John,Manager,HR,01/03/2024,Normal,0
111,John,Manager,HR,01/04/2024,OT,2
111,John,Manager,HR,01/04/2024,Normal,9
I have an excel file with emp id, name, designation, department, date, ot hours and normal hours as columns.Here are some sample data111,John,Manager,HR,01/01/2024,0,9111,John,Manager,HR,01/03/2024,3,0111,John,Manager,HR,01/04/2024,2,9222,Rogr,Supervr,MM,01/01/2024,0,9222,Rogr,Supervr,MM,01/02/2024,0,9333,Sand,PSWABCs,NG,01/15/2024,0,9333,Sand,PSWABCs,NG,01/16/2024,0,9333,Sand,PSWABCs,NG,01/17/2024,0,9333,Sand,PSWABCs,NG,01/19/2024,0,9333,Sand,PSWABCs,NG,01/25/2024,4,9My requirement is show emp id, name, designation, department, type and convert the date into column and show the ot and normal hours. Type column should show the hour type (OT or Normal)If the employee got both ot and normal, there should be 2 rows. Row 1 normal hours and Row 2 OT hours.Also, if for the month a date is missing, I still need to see that as a header column and show 0 for both OT and normal.With the above sample data, I am looking for the following results for employee 111111,John,Manager,HR,01/01/2024,OT,0111,John,Manager,HR,01/01/2024,Normal,9111,John,Manager,HR,01/03/2024,OT,3111,John,Manager,HR,01/03/2024,Normal,0111,John,Manager,HR,01/04/2024,OT,2111,John,Manager,HR,01/04/2024,Normal,9 Read More
Symbol Vertical Alignment
Can anyone tell me if the vertical alignment of a symbol can be adjusted?
Wanting to use Segoe Fluent Icons as bullets, but the fluent symbols are aligned with the top of the line space and the text is aligned in the middle.
Hoping I can get the symbol and text to be aligned. See below examples, 2nd example is using Segoe Emoji, which aligns fine. TIA
Can anyone tell me if the vertical alignment of a symbol can be adjusted? Wanting to use Segoe Fluent Icons as bullets, but the fluent symbols are aligned with the top of the line space and the text is aligned in the middle. Hoping I can get the symbol and text to be aligned. See below examples, 2nd example is using Segoe Emoji, which aligns fine. TIA Read More