Errors were detected while saving excel file how I should save it
Errors were detected while saving excel sheet how I should save it.
Excel 2016 share to mail not working
i, We are having issues with Excel 2016 and sharing it to mail. It gives this error message. Excel is running on an RDS 2016 environment and is not using any Microsoft 365 service. OS and Excel are up2date and I already did an Office repair for it,…
excel couldn't find/users/
could not open file
Excel 365 - Heavy File Opening Issue
Hi, I am facing issue with opening 20MB excel file, the file has vlookup formula from other file. The issue I am facing since today morning, the excel file taking too much time around half an hour to open that file. Don't know what update Microsoft…
Excel & Powerpoint translation fail
I used to do translation from Excel spreadsheet or Power point from Chinese to English. Several months ago, this function stops working and I get this error message. Any clues?
How can I get rid of this annoying "tic-tac" in Excel?
Several of my users are reporting that what looks like a "tic-tac" will show up in their Excel spreadsheets that they cannot close. It looks like a broken dialog box (please see screenshot). Does anyone have a solution for this? The only way…
Need help with Sync Outlook Calendar into Excel Spreadsheet
I need to figure out a way to Sync an Outlook Calendar into Excel spreadsheet without going back to the spreadsheet each time I add an event on the Calendar. Was watching video's yesterday but the concept of using codes went over my head just a little. …
How to fix keyboard issue in laptop in typing right to left and left to right.
If you're experiencing issues with your laptop keyboard where the typing direction switches between right-to-left (RTL) and left-to-right (LTR), here are some steps you can follow to fix it: Check Keyboard Shortcuts: Sometimes, the typing direction can…
Enable/Disable Drop Down List according to another value
I need to create a drop down menu, that only appears when a certain value in cell A2 is chosen (from another data validation list), but that it is disabled and blocks the cell (grey out and not possible to type anything) when the value in cell A2 changes…
Why does Excel freeze when copying large ranges and how can I fix it?
When attempting to copy a large range, Excel freezes and gradually consumes all available memory (16 GB) over a ten minute period. This issue occurs even in safe mode and repairing Office 365 has not helped. However, when running Excel as administrator,…
Run script on multiple users (using Excel table)
Hello everyone, im trying to build a PowerShell script that runs a command multiple times but with different URLs, but i cant quite understand how to build it. The point is to remove a user from the Share Point sites listed in the column D. So lets say…
Power query not loading numbers
Hello Every one, I use a query made out of excel files stored in a folder. On a regular basis, I add an excel file in the folder and refresh the query. Since the update of the 30th of May, when I refresh the query, every columns are loaded and added to…
How can I force the 'Access Web content' user authentication dialogue box to pop up using VBA?
I have some Power Queries in my Excel file that pull data from other Excel files stored on a SharePoint site. When a new user tries to manually refresh those queries using the "Refresh All" button on the ribbon (Data / Queries &…
Erro ao executar um suplemento desenvolvido em VBA
A aplicação em VBA que fiz para automatizar os meus processos rodava até no dia 24 de agosto de 2023, e após esta data passou a aparecer o seguinte erro. Erro em tempo de execução '-2147417848 (80010108)' O objeto chamado foi desconectado de seus…
When using Active X controls, a message that the object cannot be inserted appears.
When using Active X controls, a message that the object cannot be inserted appears. not available I would like to ask for your help. Thank you!
Excel file having links with different excel files opens with long delay
Hi some of our finance users are working on Excel sheet. they have one consolidated file which has link to almost 15 other excel files to fetch the data. it was working fine a couple of day ago but suddenly it is taking more than 20 minutes to open. Need…
Migrating Excel Files from On Prem to SharePoint while retaining links
We are currently planning a migration of active files from our on prem servers to SharePoint. We copied over a folder which has Excel workbooks with links to other workbooks. It appears the links do not work when opened from SharePoint. We have hundreds,…
How to include numbers with hyphens in Subtotal function
I am currently using a =SUBTOTAL formula to count a column of date but am having some issues. For example, I have 30 cells in this column that all include various numbers, but they also include numbers with hyphens— ex. 20-22, 106-107 etc. when i run…
Editing an Excel file without tables using MSGraph API
Hi all, I want to use the MSGraph API in order to edit excel files on Sharepoint. I now see that you need a workbookTable_id in order to use the python function: result = await…
How to convert Office LTSC to "normal" Professional Plus 2021?
Hi all I used this script by farag2 on GitHub to download and install just the Office applications I need (Excel, Word & PowerPoint), but it appears this isn't compatible with my product key, as displayed in the screenshot below: Why is there a…