How fix my book.
Solucionar error <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error276920_03.xml</logFileName> <summary>Se han detectado errores en el archivo…
How guest users can access semantic model from their tenant and create reports in excel online
We have a user A who is part of Tenant X , Guest Account has been created for user in Tenant Y . We have a semantic model in Tenant Y , to which user wants to connect from excel online using Tenant X Credentials from excel online . Currently when we…
Checkbox Issue 365Beta
The latest Update for 365 Insider Beta has screwed the checkboxes. Try to refer to them in a cell, which is not in the same row as the checkbox. Nothing happens with the cell, when you change the checkbox value, even "Calculate" doesnt…
Making Calls from Excel Spreadsheet
What are the steps to set up a system for making 100 phone calls directly from an Excel spreadsheet?
How to insert Sharepoint Document ID in a document (Word, Excel...)?
Hi, I enabled the Document ID in Sharepoint so each document have a unique ID. I would like to insert this Document ID in documents (Word, Excel...) but I do not have access to this property of the document (it does not exist in File > Info >…
file extension not displaying during save as
Hi, When I want to save as a file, the file extension does not display in drop-down menu! for example I mean (*xtds)
Cannot sign in to Office products after changing my Microsoft account password
I have Office LTSC Professional Plus 2024 installed on Windows 11. I've tried online repairing and all tricks and suggestions I found on the internet: registry clear, uninstall, clearing all from Microsoft in Credential Manager, detaching Microsoft…
MS Excel Drop Downs/DataValidation
Hi, for a short period of time we had the luxury in MS Excel that a drop down selection (Data Validation Drop Down and not in a table) would automatically jump to the correct first letter selection when we started typing in the cell with data validation.…
Fix Run-time error '1004'
How to I remove the Run-time error '1004', Method 'Name' of object 'Addln' failed. This Visual Basic for Applications window pops up every time I open Excel immediately after the new file appears, when I invoke "New" from the File menu and…
Problem opening spreadsheets in Excel 2016 since Win 11 24H2 upgrade
We have just updated to Win 11 24H2 and use stand alone Office 2016 Standard. We are experiencing problems with opening Excel spreadsheets from hyperlinks and File Explorer where a ~$ temp file pre-exists against the file we are trying to open. Excel…
An Excel file has been overwritten by another user.
Hello Please i need your help on this issue. I want to recover my file before a colleague overwrote it and didn't save my changes
Cannot connect Excel to Postgres database?
I would like to connect excel to a Postgres database. I have downloaded the ngpsql 4.0.17 from the below reference page https://github.com/npgsql/Npgsql/releases When I try to connect, I get this message: the ngpsql version that comes with an MSI…
How to lock events (think bills and payments) to dates in an excel calendar?
Hi there, I have a calendar in excel. Currently, if I copy the sheet and change the date in the first cell (think 1/1/2024 to 2/1/2024) the new month will populate with the dates and days correctly aligned. I'l like to lock my text to dpecific dates on…
Win11 24H2 Update Causing Selenium VBA Scripts to Fail
After updating to Windows 11 24H2, Selenium VBA scripts are unable to open the browser and return runtime error -2146232576 (80131700). The .NET Framework version is 4.8.1. Both the ChromeDriver and Selenium Basic versions are up to date, and they have…
Grant File access AcrobatUtils.scpt on Mac OS
I recently updated MS Office and Mac OS. When I attempt to open any Word document into MS Word, I am greeted with a Grant File Access permission request, which I cannot cancel out. The only way to dismiss this popup is to force quit MS Word. Why is MS…
MS Graph WorkbookApplication/Calculate API With Application Permissions
Hello, We are interested in using the API call here: https://zcusa.951200.xyz/en-us/graph/api/workbookapplication-calculate with Application permissions. It is ran on an internal server without needing a user auth workflow. A similar thread is here:…
Problem Opening Excel File After Windows Update to 24H2
Good evening. I have a PC with Windows 11 Pro and Office Professional Plus 2013. After updating Windows to version 24H2 (KB5048667 update) I can no longer open Excel files via "double click", the only way to open them is to start Excel and open…
Excel UDF Output is formatted as stale values
I have some C++ UDF developed to extend Excel functionality. With the latest Office365 version I am seeing the results from these UDFs flagged as stale data (strike through formatting). Is there a mechanism for indicating that the results from the UDF…
How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application
Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su*****sk@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing…
After win 11 24h2 upgrade unable to open / export protected excel documents
After upgrading users to Win 1124h2 from Win 1022h2 they are unable to export / open protected .xml files in excel on office2019. Have turned off enabling protected view in trust center settings, added file path in trust center settings, uninstalled,…