How to add DSN to Microsoft Excel to connect to MongoDB database?
I am trying to connect MongoDB database in Excel through BI Connector. Following are the things I have setup. Installed BI connector tool. Installed iODBC and ODBC drivers for my current MacOS version. I have mongsqld running in local. It shows the…
My Slicers are not visible in excel office 365 on my sharepoint site.
My slicers are on the excel file however, when I access it on sharepoint it seems to disappear. How can I fix this?
How to calculate duration of years in power query
I have to calculate duration between current year and the year of hire of employees. I have column set up for year of hire Currently I used formula in custom column 2023-[year of hire] how can I write a formula where I don’t have to update current…
Issue with Excel Add-In Code: Timeout Error
Our Excel add-in code is now getting a timeout error while updating cells in sheets exceeding 3500 rows. Despite smooth operation before, this issue has surfaced suddenly. We are investigating the root cause and working towards resolving it to restore…
How do i enable share workbook button on excel 365?
Hi, Please help The share workbook button on excel is greyed out, please advise on how to resolve this? Excel 365
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Excel Data Analysis Error
I am using Microsoft 365 App (Enterprise) as a student (via a university e-mail address). I need to use Data Analysis, so I followed the 'load data analysis' at the Microsoft community. And Data Analysis was showed up on the 'data' tap. But when I…
How to Fix Analyze Data Error in Excel?
Hello, I currently have issues with Analyze Data. Even though the Analyze Data option shows up on the ribbon, I am unable to use it because "it isn't set up properly." I have tried repairing Microsoft Office, repairing Excel, clicking removing…
How to Change ribbon color?
How to change ribbon and tool bar color from white to black and worksheet color from black to white? New Laptop with Windows 11 Pro. Installed Office Pro 2019. Old Laptop with Windoes 10 and Office Pro 2019 has Ribbon and Tool Bar in Blackand Worksheet…
Many spread sheets results consolidated into a Master Sheet
I have a Master Spreadsheet and other spreadsheets into teams. I want to consolidate the information from the teams spreadsheets into the Master Spreadsheet.
How do I configure Azure Table storage to authenticate with user entra ID creds?
Hello. I have a project where I have been tasked to store some simple data in Azure Table storage and then have our users query it via Excel. But in Excel when you go to Get Data > From Azure > From Azure Table Storage and then provide the…
Using pivot table grand totals for a row is not showing in excel
Grand total for a column is showing but not for rows using pivot table. Troubleshooting :have tested on a new machine , uninstall / reinstall office, Tested on web app same result , tested with a new file as well, it's a multiple user issue
How to prevent Moduls to be automatically added when switching from Excel do VBA Editor with <Alt>F11
Hello When opening Excel and switching from Excel to VBA Editor with <Alt> F11 the following happens: PC 1: A Module is automatically added to the active workbook PC 2 and PC 3: Nothing happens Why does this happen and how can the automatic…
READ-ONLY We opened this workbook read-only from the server WARNING
What might be the reason (or is it by design) that if we open Excel Files from our on-premises SharePoint 2019 we get this waring ribbon saying "READ-ONLY We opened this workbook read-only from the server --> Edit Workbook", while this is…
Excel slow to open second (or subsequent) file
I use MS Office Home & Business 2019 on Windows 10 PRO and my computer is quite fast (i7 processor, with 32gb RAM and and ssd drive). I have the following problem when opening Excel files (only when double clicking files from Windows Explorer): …
How to add February 29 (leap year day) to Pivot table?
I noticed that that data in my pivot table does not include February 29th in the table, which is the leap year day. I'm not sure how to add it into the table, since it is formatted correctly in the other sheet. How would I be able to add this? Thanks!
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Accéder sur Android à un fichier protégé par mot de passe sous windows 10
Bonjour, J'ai un fichier excel (version 2013) sous Windows 10 protégé par un mot de passe. Et qui et stocké sur mon Drive. Je veux pouvoir y accéder depuis mon telephone portable qui est sous Android. J'ai systématiquement une erreur "Impossible…
Excel File Saved on OneDrive, Password Protected, Won't Let Me Get in Write Mode When Someone Else in READ
Hi, I have a password protected file saved on One-Drive. If someone else in my organization is in the file in READ-ONLY mode (they are NOT co-authoring) it won't allow me to get in the file in Write mode. This does not happen on a normal network drive,…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
如何使用write这个用法
如何使用write这个用法不太懂 SD関連トランザクションコード一覧 販売管理 受注 T-code``名称``更新/照会``VA01``受注伝票登録``更新``VA02``受注変更``更新``VA03``受注照会``照会``VA05``受注伝票一覧``照会``V.02``不完全受注伝票一覧``照会`` 分納契約 T-code``名称``更新/照会``VA31``分納契約の登録``更新``VA32``分納契約変更``更新``VA33``分納契約照会``照会``…
Doesn't show the AutoSave button
Hi........! Please answer me, My MS Excel doesn't show the AutoSave icon/ (on and off button) on the top of the left-hand corner. why so that? please give me a solution. My other MS Office products (MS Word, Powerpoint, etc.... are shown it). please sort…