Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,580 questions
1 answer
Excel一直還原未存檔的部分會流失
使用EXCEL過程中,一次閃爍,便自動還原到未存檔 過程中所有未存檔資訊全未存檔,檔案並沒有關掉, 還原到剛從存檔中叫出來的樣子
asked 2024-06-11T05:43:44.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGW%3C/text%3E%3C/svg%3E)
g water
0
Reputation points
answered 2024-06-11T07:12:09.7966667+00:00
Emi Zhang-MSFT
22,796
Reputation points Microsoft Vendor
2 answers
Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11
Hi everyone, I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues. When using the SSIS process and…
asked 2024-06-10T20:42:40.8233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Majid KH
0
Reputation points
commented 2024-06-11T06:39:44.1633333+00:00
ZoeHui-MSFT
34,351
Reputation points
1 answer
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!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 51%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
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…
asked 2024-05-03T06:41:10.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
VenkataRamiReddy Pulikhandam
20
Reputation points
commented 2024-06-11T03:39:55.1933333+00:00
VenkataRamiReddy Pulikhandam
20
Reputation points
1 answer
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. …
asked 2024-06-10T14:59:38.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGH%3C/text%3E%3C/svg%3E)
Govea, Hugo
0
Reputation points
answered 2024-06-11T02:09:48.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 48%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
Faery Fu-MSFT
17,636
Reputation points Microsoft Vendor
0 answers
Excel shape resizes when moved
I am having issue with this code below. I am attempting to copy and paste a shape to certain position. When I adjust the .top and .left property of the copied shape the height and width get altered slightly from the original. Why is the shapes height and…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,580 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,627 questions
asked 2024-06-10T16:47:21.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Patrick
0
Reputation points
edited the question 2024-06-11T01:09:36.9266667+00:00
Emi Zhang-MSFT
22,796
Reputation points Microsoft Vendor
2 answers
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,…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 14.000000000000002%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
2 answers
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…
asked 2024-06-10T08:03:49.4266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 7.000000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Emiliano
0
Reputation points
edited a comment 2024-06-10T16:18:53.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rich Matheisen
45,341
Reputation points
2 answers
Large Excel file: Suddenly the links are shifted to the cell in the preceding row.
I have a large Excel file (8025 lines). (Microsoft® Excel® 2021 MSO (Version 2405 Build 16.0.17628.20006) 64 Bit) One column (column C) contains names of historical persons; example: Victoria (Vereinigtes Königreich) To each cell (= historical person)…
asked 2024-06-06T06:13:52.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hans-Heinrich Hartmann
0
Reputation points
commented 2024-06-10T15:58:15.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 26%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Barbara Verplancken
0
Reputation points
1 answer
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…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,580 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,627 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,038 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,667 questions
asked 2024-06-09T08:51:27.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 30%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Freja Tara
0
Reputation points
answered 2024-06-10T03:01:59.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
6,345
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-06-08T06:19:49.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI1%3C/text%3E%3C/svg%3E)
it-1048
0
Reputation points
answered 2024-06-10T02:42:15.2866667+00:00
Jiajing Hua-MFST
6,345
Reputation points Microsoft Vendor
2 answers
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…
asked 2024-06-08T16:55:06.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 16%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
love to learn anything
0
Reputation points
commented 2024-06-10T02:27:33.9866667+00:00
love to learn anything
0
Reputation points
1 answer
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…
asked 2024-06-05T15:07:46.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sajid Ali Shah
236
Reputation points
commented 2024-06-07T13:32:57.4733333+00:00
Sajid Ali Shah
236
Reputation points
1 answer
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…
asked 2024-06-06T09:30:47.1233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 5%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anil Kumar Thakur
5
Reputation points
answered 2024-06-07T06:01:28.9233333+00:00
Jiajing Hua-MFST
6,345
Reputation points Microsoft Vendor
1 answer
This action couldn't be performed because Office doesn't recognize the command it was given
Has anyone seen this error? "This action couldn't be performed because Office doesn't recognize the command it was given" This is for an Excel file I cant open in the Start search menu but can open it through the web browser while…
asked 2024-06-05T21:05:27.34+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 35%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anthony Garcia
0
Reputation points
edited a comment 2024-06-06T14:22:58.7266667+00:00
Anthony Garcia
0
Reputation points
1 answer
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…
asked 2023-07-27T18:02:46.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 43%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Nicholas Rynard
0
Reputation points
commented 2024-06-06T12:05:47.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Emmanuel
0
Reputation points
1 answer
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 !!!
asked 2024-06-05T14:40:32.4233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 10%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sofia
0
Reputation points
answered 2024-06-06T01:58:48.75+00:00
Emi Zhang-MSFT
22,796
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-05-15T01:48:39.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 84%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bjorn
0
Reputation points
edited the question 2024-06-06T01:40:35.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 92%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Roy Li - MSFT
32,646
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
0 answers
Workbook Excel API for personal OneDrive accounts is not working
This API https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0&tabs=http was working fine for Personal OneDrive accounts but it has stopped today on 6/4/2024. It is returning with the following error. The same error…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,002 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,580 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
896 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,627 questions
asked 2024-06-04T17:12:21.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Abhishek
5
Reputation points
edited the question 2024-06-05T07:40:20.2566667+00:00
Jiajing Hua-MFST
6,345
Reputation points Microsoft Vendor