Recent Discussions
Copying column widths and row heights from one sheet to another
Hello everyone. I have to reformat a rubbish PDF i get sent everyday so i can make it legible. i have arranged the cell widths and heights and cut and pasted the data but there are 14 columns and as many as 30 rows. I have this information on PDF everyday. Is there a way i can automate this so my sheets are all the same looking?Excel workbooks keep breaking
Hi All, Sorry if this is not the right place to ask, I'm new here. Since a couple of days, my Excel workbooks keep breaking. When opening specific files, Excel states the file needs to be repaired. Everytime certain formulas are being deleted and the values are just pasted as is. I haven't had any issues with these files in the past. Previously I used a license which I bought online via a third party. It seems the issues started after an update. I switched to a license which I bought directly from Microsoft. I did a clean installation, removed all the previous versions files but the issue still exists. For a couple of days I can open the files without problems. And then yesterday excel showed an update was available and excel had to be reopened. After doing so, the issues came up again. I have a Office Home 2024 License, Excel version 16.106.1, on macOS Tahoe 26.2. T.I.A
Can I restore my whiteboard created by Microsoft Whiteboard UWP?
I created several whiteboards by MS Whiteboard UWP in 2023. As I cannot transfer the data to new Whiteboard, I kept the old version ( Microsoft.Whiteboard_52.10201.5809.0). But days ago MS Store updated it automatically, and I lost my data. I didn't transfer it to OneDrive, so it should be stored on Azure. When I find the update (when it updated the local data should be already removed from my device) and recover the old version and login again today, I find nothing but a new created empty whiteboard, all of my data lost and I cannot access it from the cloud. How can I recover my data?
Excel array question - spill VOWD based on forecast month
Hi, Can I have your help on a spilled question? I have the following table with information. Fore Month Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26 VOWD 2 - - - 3,983 15,203 11,779 2,083 - 1,742,162 1,696,156 116,267 1,162,366 - 2 - - 100,000 200,000 - - 500,000 650,000 300,000 - 466,000 - - 3 - - - 3,983 15,203 11,779 2,083 10,000 1,742,162 1,696,156 116,267 1,152,366 - 3 - - 100,000 200,000 - 250,000 250,000 650,000 - 400,000 450,000 - 100,000 4 - - - 2,000 15,203 11,779 2,083 10,000 1,742,162 1,696,156 116,267 152,366 2,000 4 - - 100,000 200,000 - 250,000 250,000 650,000 - 400,000 350,000 - 300,000 I would like to have a spilled array formula in VOWD column and the expected result is right there now. The logic is to grab the first 2 columns and sum up the amounts for the first two rows of data, and grab first three columns and sum up for the third and forth rows of data and etc. Thanks, Anna
Functions and formulars
Hi all, yes I am struggling to find the right formular for a problem, or to get it to work. I have a number in cell B14, which i want to return a value in cell B13. if B14 gives a value between 30 and 49 (this is manually entered) the result in B13 should be Pink (the word not a coloured cell) and if B14 gives a value between 17 and 33 the result in B13 should be Purple plus a few more along these lines and if the B14 value is under 9 result should be Yellow I am frustrated... this used to be simple for me but its been a while and any help would be appreciated.
Publish an Excel Add-in by just submitting the add-in manifest to Microsoft Marketplace
I am working on Excel Add-in built using the react template. We are planning to host the add-in code on our domain and update the manifest to point to the URL for our domain. Can I just submit the add-in manifest to Microsoft to publish it in Microsoft Marketplace?
Formula Help
I have a spreadsheet I use for bidding construction work. On items 1-40 the formula in cells G22-G65 work like they are supposed to. From G66 to G88 where the sheet stops, the formula returns #NAME?. I've checked the formula from G65 to G66 and below, and they appear to be correct. I can't figure out what the problem is. This is the formula that works. =IF(D65>0,'40'!Rate+$G$18,0) This is the formula that does not work. =IF(D66>0,'41'!Rate+$G$18,0) The '40' and '41' refer to individual sheets within the workbook that contain the data in the !Rate cell. I've been looking at this for hours and can't figure it out. Any help or advice would be great.Microsoft Takes Aim at ChatGPT
Microsoft would very much like Microsoft 365 tenants to use Copilot instead of ChatGPT. A recent comparison between Copilot and ChatGPT outlines some areas that Microsoft thinks are important when deciding which AI tool to use. Microsoft has a point because Copilot is embedded into Microsoft 365 whereas ChatGPT is more of an add-on. The competition for hearts and minds is very intense in the AI space. https://office365itpros.com/2026/02/20/copilot-and-chatgpt/Using Dev Proxy with the Microsoft Graph PowerShell SDK
Dev Proxy is a Microsoft tool built to help developers figure out the most effective way of using Microsoft Graph API requests. On the surface, Dev Proxy doesn’t seem like a tool that would interest people who use the Microsoft Graph PowerShell SDK to write scripts for Microsoft 365. But all tools have some use, and Dev Proxy can help. https://office365itpros.com/2026/02/19/dev-proxy-graph-sdk/Access to subAddress Property of Hyperlinks in Powerpoint Javascript API
Recently my company has me developing a Taskpane Add-in for Powerpoint using the Javascript API. Right now the API is still missing a 'subAddress' property for the Powerpoint.Hyperlink class. My heart's deepest longing is to add a slide to a presentation with existing slide-to-slide hyperlinks, check those hyperlinks for discrepancies between the slide ID and the text (ie: a Hyperlink reading '13' that now links to slide 14), and finally correct the text to the subaddress ID of the hyperlink in Javascript. It is my burning passion to do this for every hyperlink in my presentation with the push of a button. In the interest of all mankind I would ask that the 'subAddress' property of the hyperlinks be available for use in addition to the 'address' and 'screenTip' properties which now exist. To the microsoft dev who can grant me this boon I offer half my kingdom. Truly there is no dev more favoured than thee.How to Use Scoped Graph Permissions to Access SharePoint Files
Scoped permissions grant apps granular access to files and folders in SharePoint Online and OneDrive for Business sites using the Files.SelectedOperations.Selected Graph permission. The permission allows apps to access specific files or all the files in a folder. It’s a great way to make sure that apps don’t have unfettered access to confidential documents. Not that any app would try to have that kind of access… https://office365itpros.com/2026/02/18/scoped-access-files-and-folders/
Organizational Account authentication problem
I have encountered a new authentication problem using an organizational account with Get Data > From Web. The data source is Dynamics 365 CE on-premises (https://ce.xxx.com/api.data/v9.1), authenticating through ADFS with MFA. This has been working without any issues until recently. When I attempt to refresh the query, I get an ADFS pop-up window for username and password, as expected. However, the window then closes without the expected MFA prompt. The "Access Web content" window does say "You are currently signed in," but does not query successfully, instead displaying the error "We couldn't authenticate with the credentials provided. Please try again." The most distinctive symptom, is that clicking the "Sign in as different user" button does not work. It just quickly opens and closes an empty window, instead of the expected ADFS username/password page. In Power BI Desktop everything works. The connection and query are successful, and the "Sign in as different user" button successfully displays both the initial ADFS username/password window and the subsequent MFA dialog. Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2512 Build 16.0.19530.20226) 64-bit
Onedrive sharing not working for one user
There is only one user who cannot share with anyone external or internal. I have checked everything, they are a site owner, a site admin, a site member, we have no restrictions on sharing, it works for others. I made a new site just for them as the only admin, they still cannot share. They have been removed and re-added 5 times. We have a microsoft support ticket and they don't even seem to know the issue. What can I do?Time sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!Tender Tracker formula help
Hello, I am creating a spreadsheet to track tenders for various part numbers so that I can track when each part number is up for renewal. Is it possible to create a formula which based on the tender renewal date, excel would colour fill the row up until that date which is in the top row? Example screenshot. Not sure how to add an excel filePrimer: How to Use RBAC for Applications to Control App Use of the Mail.Send Permission
The temptation to use the Mail.Send application permission in scripts can lead PowerShell developers into trouble because the permission allows access to all mailboxes, including sensitive executive and financial mailboxes. Fortunately, RBAC for Applications allows tenants to control the access that apps have to mailboxes and other Exchange content. All explained here with an example script to test RBAC of Applications. https://office365itpros.com/2026/02/17/mail-send-rbac-for-applications/
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- AI isn’t a side conversation at the Microsoft 365 Community Conference—it’s at the center of how work is changing. The Copilot, Agents, & Copilot Services Sessions are designed for anyone who wants t...Feb 20, 2026
- Version 2511 (Build 19426) Bug Name Issue Fixed Query Design view showed incorrect joins after selecting SQL text When using the Monaco SQL editor with a query containing mul...Feb 18, 2026
