office 365
16344 TopicsExcel authentication token reuse for access to Log Analytics
I have noticed that Excel is not able to reuse the authentication token when accessing Log Analytics workspaces if an expired token was renewed for a single sheet in a workbook. Scenario: 1 workbook with 1+ worksheets Each worksheet is a different query to LA (KQL query displayed in Excel for ease and consolidation) Access to LA is protected by the usual access controls (Conditional Access; Security Reader role + Session control) After a period of time, session and token expire and require renewal User receives a prompt stating the token has expired and needs to be renew User clicks on "Sign-in" and successfully completes the prompts (u/n+pwd+MFA) Expected result: The new token will be reused for subsequent connections to LA within the same workbook Actual result: User is prompted to re-authenticate for each and every connection in the workbook resulting in as many auth requests as there are connections Workaround: After successfully completing the first auth request, close Excel and re-open it and run "Refresh all" This successfully completes refresh of all data without any additional re-auth requests Is this behaviour by design or due to a configuration? Is there a way to address this so that the first token is re-used by all other connections without having to close and reopen the workbook?6Views0likes0CommentsTrying to fill Column using partial match from another Sheet
Not super tech nor Excel savvy, so I'm having issues trying to put words on what I'm trying to do for a Google search. Basically, I have an Excel file with 3 sheets; one has a list of all my company's clients with their phone numbers, one has a list of 400+ of the clients from the first sheet and a third one has a list of 80 of those clients. I'm trying to extract my client's phone numbers from the first sheet to both the others. My clients have numbers that can range from 1234-0 to 123456-0. The "-0" part can only be "-0" or "-1", but the first part ranges from 4 to 6 various numbers. However, both Sheets 2 & 3 have the number as is, while Sheet 1 has the first part in a column and the "-0" or "-1" in another column. In short, on the tables below, I think I would need a fonction in sheet 2 & 3's "Phone Number" column which could compare Sheet 1's "Client Number" column with Sheet 2 & 3's "Client Number" and if it finds a partial match (because of the "-0" or "-1" difference) extracts the info in the corresponding "Phone Number" column to the empty "Phone Number" column on Sheet 2 & 3. Using Excel version 2511 if that's useful. Sheet 1 (Full list) : Client Number -0 / -1 Client Name Phone Number 123456 -1 Microsoft 1234567890 9876 -0 Apple 9876054321 Sheet 2 & 3 (Smaller lists) : Client Number Client Name Phone Number 123456-1 Microsoft 9876-0 Apple70Views0likes5CommentsFormula help - daily pay vs supplement monthly payments
Hi all, I have two sets of data for bonus calculations. SET ONE is in multiple rows by employee, e.g. the annual pay from 1 Jan to 31 Mar. Then 1 Apr to 31 Dec - when their pay has changed from 1 Apr onwards. And then a count of the number of days per row. I use this count to calculate the annual bonus. SET TWO is any annual supplement paid, by calendar month, that I need to split by days relevant to their pay in SET ONE and add to their salary for that period. So how can i take the data in SET TWO, and split by the same time period in SET ONE - and cut the Supp Amount and add to the Supplement Row column, thus updating the Total Paid column? I have 2k employees to calculate e.g. Thanks233Views0likes7CommentsHow to separate non-indented number points from indented number points?
I'll explain. I have a document that's about fifty pages in length, with about 500 numbered points in total. The list randomly is dispersed going down, with some numbered points having no indentation while some have it (text down and to the right, down to the right and so on). It looks like this: Example 1 (Actual Layout): This Is An Example How The Document Is Listed Trying to sift through it all and sort the list manually is proving to be too time consuming. Trying to sort the lists alphabetically left all the indented text out of order with no way to figure out what numbered point it belonged to what. It looked something like this: Example 2 (Alphabetized Layout): An Document Example How Is Is Listed Of The This Is there any way to have it so word can separate Example 1's points, 1, 4, 5, 6, and 7 and points 2 and 3 away from each other, creating two separate lists with all the indented numbered points all corresponding to the correct main indented point? Like this: Example Three (Desired Layout): This Is The Document Is Listed Is An Example How Thanks. Sorry for the length.91Views1like4CommentsExcel Power Query crashing 0xC000026F
Hi, I have the same error that was already reported by other users 0xC000026F. Since today, I have an error when I try to create a new “basic query” or if I try to refresh an existing one which was working fine last week (on January 22 it was still working fine). Error Message: Container unexpectedly exited. Exit code: 0xC000026F. PID: 19148 … From what I see my Excel is Version 2512 (build 19530.20184) from 21 January 2026… I am wondering if it is this update which crash PQ ? I have already tried: sfc /scannow then dism.exe /online /cleanup-image /restorehealth Without success… Any help would be appreciated. Regards,19Views0likes0CommentsChart from dynamic array challenge
Hi (Excel 365 v2512 b19530.20144 Current Channel / Windows 11 25H2) Charts are definitively not my thing. Spent hours on the following, searching, testing… to no available The below chart data range is a dynamic array (could be wrong for the desired chart) - named GRAPH_Series on sheet GRAPH_Ranges - similar to the array on the left side of the pic. The arrays dynamically resize according to the 'START Year' & 'TOPN Cat' variables - so far so good Setting the Chart data range as =GRAPH_Ranges!GRAPH_Series and changing nothing else, the chart updates as expected according to 'START Year' & 'TOPN Cat'. On the other hand if I change anything in the Select Data Source dialog box the chart won't update properly anymore The expected chart is the same as above with 2020, 2021...2025 (instead of 1, 2,...6) horizontally & D, F, B, A as legend Thanks & any question please let me know Lz. EDIT: Cross posted here on Jan 29, 2026139Views1like0CommentsCANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?731Views3likes8CommentsOffice v2508 feature update (new vbe7.dll) breaks library compatibility with LTSC VL versions
Since the Jan 2026 updates, some `accde` or `mde` libraries built with the semi-annual enterprise channel (v2508, Build 19127.20484) can no longer be used with the volume-licensed version of Office LTSC (tested with the Jan 2026 release of Office 2024 LTSC VL, v2408, Build 17932.20638). The reason for this seems obvious: The v2508 feature update contains an updated vbe7.dll. Apparently, this change is backwards-compatible (code compiled with the old dll will run with the new dll) but not completely forwards-compatible (code compiled with the new dll might not run with the old dll, even if the new RegExp class is not used). That's a problem for us. We can't just tell our customers to upgrade, because those with an Office 2024 LTSC volume license already use the latest version available to them. Does Microsoft consider this a bug or "by design"? If the latter, what is Microsoft's recommendation for software vendors who want to build software that runs on all currently-supported versions of Access? We currently plan to work around this issue by installing v2502 of the semi-annual enterprise channel on our "build VMs" (32 and 64 bit) and use those to build our software. (Reverting dev machines to an old Office version is not an option for obvious security reasons.) Repro On a PC with v2508 or newer: 1. Create a new mylibrary.accdb with a module with the following code: Public Function GetColorCode() As Long GetColorCode = vbRed End Function 2. File/Save as/Create accde. 3. Copy mylibrary.accde to a PC with v2507 or older (for example, with the current version of Office 2024 LTSC volume license). On a PC with v2507 or older: 4. Create a new database. 5. Create/Module/Tools/References 6. Add a reference to mylibrary.accde 7. Add the following code to the module: Sub Test() Debug.Print GetColorCode() End Sub 8. Debug/Compile Expected result: The database compiles. Actual result: "Compile error: Can't find project or library". The "references" window opens automatically and highlights "mylibrary". Notes We are not library developers, but we are still impacted by this issue, since the software we ship consists of a (modifiable) startup mdb referencing an (unmodifiable) mde containing the business logic. If you want to try to reproduce this issue but don't have a volume license of Office 2024 LTSC lying around (we certainly don't), you can install a trial version with the Office Deployment Tool and the following configuration file: <Configuration> <Add OfficeClientEdition="64" Channel="PerpetualVL2024"> <Product ID="ProPlus2024Volume"> <Language ID="en-us" /> </Product> </Add> </Configuration>155Views0likes5CommentsAccess Distribution Package
I am sure this has been asked before but her is my design... 1) I have built an Access database application the distribution tool has the ability to display a folder picker that asks the admin for the <root> (NAS< Fileserver, etc.) copy the Backend or database files to that selected <root> create a Workstation Install tool file copy completed relink frontend to backend file system create a shortcut link on the workstation desktop This is a very simplified description, but I believe that it is not an unusual request. thanks for all your assistance in advance. SquireDude64Views0likes2Comments