Excel一直還原未存檔的部分會流失
使用EXCEL過程中,一次閃爍,便自動還原到未存檔 過程中所有未存檔資訊全未存檔,檔案並沒有關掉, 還原到剛從存檔中叫出來的樣子
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Require sample data sets for better practice
Hi Team, I am requesting that you please provide the sample data sets to experience real understanding and gain quality knowledge. I am learning to be a Power BI data analyst. Please guide me to where I can download the data samples to practice and…
My admin-managed Excel Office.js add-in is not appearing on iPad
Hi there, I've developed an Office.js excel add-in which has recently been deployed by my organisation through Integrated Apps. The add-in works perfectly on MacOS and through the browser, but I would like to use it on iPad. The 'admin-managed' add-in…
using golang msgraph-sdk-go to access user's workbook in their onedrive within the same organization
Hi, my goal is to create a background app that can access(read/write) one of the user's workbook(excel) in their onedrive within the same tenant (or organization. i am using the example app-only https://github.com/microsoftgraph/msgraph-training-go and…
Excel connect to SQL Server using a different windows user name
hello, I am trying to connect to SQL Server in MS Excel using a different windows user credential other than current logged on windows user ID. using SQL Server database user name is not an option for me. Is there any function that can impersonate in…
EPM (SAP Add-in on Excel) reports entirely greyed out
Hello Microsoft Community, I have recently had the EPM Add-in (SAP connection) installed on my excel and I've found that my reports are entirely greyed out. Below are images showing my unusable report screen and my colleagues functioning screen for…
How to add Analyze data if already add
Hello, I already add-ins Analysis ToolPak and Analysis ToolPak - VBA but The Analysis Data tool does not appear on my Home. My Excel is Version 2405. How & What should I do? Please Help Me !!!
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
How to upload add-in to excel store for review?
Hi, we are a new startup and have developed an add-in that we want to upload to the store for others to use in excel. I have been struggling four a couple weeks now to find out how to get this uploaded for review. I created a work account on Microsoft…
matching data issue in if formula
I am trying to compare two columns of data, which are formatted as dd/mm/yyyy to check they match, using a very simple IF formula: =IF(A2=B2,"match","not") Visually those which match are producing a "not" result, even though…
Not able to create multiple long running session for a single excel file using Microsoft graph workbook api.
We can create multiple long-running sessions for a single file using the Microsoft Workbook Create Session API, and the older sessions remain active for a short time. However, sometimes we receive an accepted (202) response when creating a new session,…
Create Outlook Subfolder and Rules via Excel Macro
Can one from an Excel macro auto-create Outlook Subfolders and Rules (associated with Subfolder). I know one can create emails via VBA / Macro
FileOpenUserUnauthorized error for excel API
Hi, I hope you are doing well. I am exploring Microsoft Graph Explorer for excel API and testing get worksheets in workbook endpoint. Although I have provided correct drive-item-id , I'm keep getting following error. { "error": { …
Writing a Comparison function for Excel Visual Basic
I'm new to Visual basic and I'm currently trying to write a simple piece of code to Compare value of the cell in 2 different columns. If the values are the same, then I want to fill in cell Green in a third column, used for the comparison result. If the…
Remote Desktop Mobile (RD Client) on iPad not sending shift keyboard combos to Excel
The Microsoft Remote Desktop Mobile app (RD Client) on iPad does not send many keyboard combinations correctly to Excel. I am using an 10th generation iPad with a keyboard to connect to two PCs running Windows 11 Pro to run Excel. Whether I connect to…
How to take information from a Form and transfer the data into a word document
I am trying to take answers from a Microsoft Form and transfer them into a Word document. I have done it with Google forms, sheets and docs using the autocrat extension but I need to be able to do this in Microsoft.
Creating Excel with EPPlus: Set Column Widths in Pixels and Add Logo
Hello Friends; I have a question for you, I want to pull the data according to id and process it with excell, I even want to add a logo but I couldn't do it somehow, the thing is that I actually want to give the size to the columns and add a logo, but…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Error when looping through Access queries from Excel - "Too many client tasks"
I have a workbook that has many MS Query connections to an Access database. The workbook has been working great for years, but recently it stopped working after the 64th refresh. First I get a dialogue "Select data source", where MS Access…
How do I create an excel file for csv export
How do I create an excel file so that it can be converted to a csv file to be exported into quickbooks online
![](https://techprofile.blob.core.windows.net/images/_KR_hQAAAwAAAAAAAAAAAA.png?8D8440)
MSQuery is has gone from GetData From Other Sources in Microsoft 365 Excel
I have been using MS Query MSQRY32.exe to access data in a 32 bit database using 32 bit DSNs for 30 years. Today I find that MSQuery has been removed from Excel-GetData-From OtherSources. MSQRY32.exe works if I run it directly. It is simply missing from…
Excel file with view permission won't open in desktop app got you don't have permission to open this file
Hi team, We granted a user view permission to an excel file. The user can open the Excel file from the web but encounters a "You don't have permission to open this file" error when trying to open it from the desktop app. Thank you for your help