Recent Discussions
PowerPivot not returning correct data
Hello, In the following link you will find a PowerPivot that is referencing 2 specific tables with Inv# being the common field between the 2 tables. The PowerPivot is bringing in Troy Ounces and Revenue by Invoice #, Fiscal Period and Department. Unfortunately the total Troy Ounce amount is being repeated under each Invoice #. It should be showing the respective troy ounce by what the invoice is recording. Is there a specific reason as to why the PowerPivot is not bringing in the correct troy ounce weight? Hope you can point me in the right direction. Here is the link: https://docs.google.com/spreadsheets/d/1QSu-QluTTAZBPsHtXhmkGoTezkPJv4Qp/edit?usp=sharing&ouid=103354753371375324640&rtpof=true&sd=true
changing working times on an existing Project file
I have a large MS Project that was prepared using the standard calendar, but that calendar uses different daily shift times than what we want to use. I created a new calendar with the correct shift (working) times, set the Project to use that new calendar, but the old calendar times are still being used for new tasks, and existing tasks still have the old calendar times. I even changed all the individual tasks to use the new calendar with no effect. How can I force an existing Project use the correct calendar?Inserted Excel spreadsheet in Word not updating with added rows
Hi, I have inserted an Excel spreadsheet into my Word document via Insert --> Table --> Excel Spreadsheet. The contents of this spreadsheet show up in my Word document. However, if I insert a new row in Excel, while the row's contents show up and save in the Excel file, they do not appear in the Word document. This seems to be happening particularly if the new rows are added towards the bottom of the table. I cannot figure out why this is happening and there is plenty of space in the Word document for the new rows to appear. I have tried expanding the size of the table in Word and still no luck. Any assistance would be appreciated. Thank you.
How to Account for Inflation
Attached I show an account balance forecast going out 20 years. But 20 years from now, $176,560 won't feel like $176,560 feels today. So how can I reflect a 3% annual inflation rate in each of the years? Each year's balance is based on many "ins and outs" of money, so I can't just calculate using a rate of return less inflation. Thanks in advance!Customize theme fonts Word
I cannot set custom font sets/theme fonts as this feature seems to be missing in my version. See attached screenshot where I compare the option on my computer to option that is showed on an online support. As you can see I don't have the "Customize Fonts" feature button. I have a Mac and and Office 365. Grateful for help.
Switching off comment notifications in word documents
Hi - is it possible to turn off email notifications for replies to comments in a word document? We seem to get a notification about new comments every time the document is saved, and as Word autosaves, this is getting to be fairly frequent on large documents with lots of discussion! We actually don't need to be emailed at all so if there's a way to disable the notifications altogether that would be great.Access Abfrage Schaltfläche Ausführen! deaktiviert
Seit Tagen ärgere ich mich in Access über den folgenden Sachverhalt: Ich habe eine DB erstellt. Ich habe eine Abfrage über den Abfrageentwurf erstellt. Dies funktioniert korrekt. Wenn ich jedoch im Abfrageentwurf die Schaltfläche "Ausführen!" betätigen will, ist diese deaktiviert. Microsoft Support ist nicht in der Lage oder Willens diesen defect zu beheben. Ich habe dieses Problem schon in der Tech Community aufgeschaltet, erhielt die verschiedensten Antworten. Ich erhielt den Rat im untenstehenden HKEY die Anpassung vorzunehmen. Schon der der Ordner Access Connectivity etc. fehlt auf meinem Rechner... HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office[Version]\Access Connectivity Engine\Engines\SandBoxModeHave you ever wished Excel could calculate faster — maybe even use your GPU?
I’ve run into performance walls with large Excel spreadsheets — especially ones with complex formulas or large datasets. For example, dealing with time series of market data where they don't all have the same set of holidays and trading days. Even with only 20 years of daily data, having more than a few tickers can make changing one cell take 30 seconds while it all recalcs. I’m wondering if others have hit similar limits. - Have you ever wished Excel could use your GPU to speed up recalculation? - What kinds of sheets or formulas caused the slowdown? - Did you find any workarounds, or just live with it? I’m looking to hear what kinds of spreadsheets people struggle with most, and tips for how they got past them if they did.
Search for a date in a row does not work in VBA with ".find" when column is too narrow
I have a row with dates (row 3) and a cell with a date (C7) I want to get the column where this date (C7) is in that row3 This is my code: Sub find_date() Dim datum As Date Dim zoekrij As String Dim cel As Range datum = Range("C7").Value zoekrij = "A3:Z3" Set cel = Range(zoekrij).Find(DateValue(datum), LookIn:=xlValues, LookAt:=xlWhole) If Not cel Is Nothing Then MsgBox ("Date found in column: " & cel.Column) Else MsgBox ("Date not found") End If End Sub This works when the row 3 is formatted as date and the column is wide enough, but when the column is too narrow and shows "####" the date is not found. I also tried to use Clng(datum) and formatted the row as numeric, but with the same result (works only when column is wide enough)
Excel Does Not Sync Until Opened
I created a form linked to an Excel spreadsheet in SharePoint as well as a Power Automate approval flow triggered on submission. In addition to sending out confirmation/approval emails, the flow also updates the associated Excel spreadsheet with the approval/denial. The flow was working fine until last week but since then has failed 2 consecutive times. The failures appear to be related to the flow unable to find the automatically generated submission ID in the Excel spreadsheet. When I open the linked spreadsheet, the submission is not immediately present at first but the file does sync at that point and the entry appears. When re-triggered after the sync, the flow completes successfully. Not sure if it is related, but MS form/linked spreadsheets have been updated by Microsoft recently and I was prompted to go through an update process for synced Excel spreadsheets. I completed the update with this specific form last week after the flow failed for the first time. TLDR - my form only syncs with the spreadsheet once opened. Any ideas how to get MS Forms to update the spreadsheet in real-time as opposed to when it is opened?
How can I use Pivot Tables to keep two worksheets of user information and add rows for new users?
I have a large spreadsheet that is used by my organization to keep track of users and all types of information about them including Roles, account requests, corporate training, system access, industry certs, etc. I want to break the spreadsheet up into two spreadsheets (same workbook) that reference the same users but breaks up the different information based on the auditor (Auditor A reviews account requests and corporate training, while Auditor B reviews system access and industry certs. I've created a pivot table of the first two columns of the Master and copied the contents into the AuditorB spreadsheet, but when a new row is added for a new user to the source it doesn't create a new row for the AuditorB spreadsheet. I've tried creating tables on both spreadsheets but it only updates the contents of column A and B, leaving the rest of the data in the AuditorB spreadsheet as static. Can someone direct me to how to get this to work? I'll try uploading a dummy spreadsheet of the format of the spreadsheet that I work with. If there's a different more efficient way to achieve my goal I am open to it; I don't have to use Pivot Tables if there's a better way. Thanks in advance!Automating Microsoft 365 with PowerShell Second Edition
The Office 365 for IT Pros team are thrilled to announce the availability of Automating Microsoft 365 with PowerShell (2nd edition). This completely revised 350-page book delivers the most comprehensive coverage of how to use Microsoft Graph APIs and the Microsoft Graph PowerShell SDK with Microsoft 365 workloads (Entra ID, Exchange Online, SharePoint Online, Teams, Planner, and more). Existing subscribers can download the second edition now free of charge. https://office365itpros.com/2025/06/30/automating-microsoft-365-with-powershell2/Using comma as separator in Forms
I live in The Netherlands and we use a comma as a decimal separator. However when I use Microsoft Forms it doesn't accept the comma, it removes it. See below. Both Windows and Google Chrome have the right regional settings, namely Dutch. The strange thing is that when I do the same in a Sharepoint list, it works correct. So the problem seems to be with Microsoft Forms. Any ideas anyone? ps I have also set the primary language to Dutch.
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- We’re excited to introduce a wave of new capabilities that help you surface rich insights from your enterprise data and unlock new levels of productivity.Nov 21, 2025
- 3 MIN READMany of you have asked for the ability to choose the length and tone of your presentation. We listened!Nov 18, 2025
