Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
0 answers
Showing % of Pivot Table Field that is Not in Group - #N/A Error
Hello everyone, I am working on a report using a pivot table that summarizes data in a category > group > label hierarchy. The pivot table rows are based on Category, Group, and Label, and the columns are the values. For each row, I need to show…
![](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(304, 16%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
How to handle an excel sheet(only 1 tab) with multiple datasets with different columns and ranges
Hi Team, Could you help me out with below Scenario of ADF? I have a single Excel file with just one tab, as displayed below with different columns and that tab contains 2 datasets. We want to move this data to 2 different SQL tables using ADF/data flow.
asked 2024-07-24T12:35:32.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(51.2, 56.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Spandana Mogadala
0
Reputation points
commented 2024-07-24T13:55:41.3333333+00:00
Nandan Hegde
31,511
Reputation points MVP
2 answers
Getting an error when export a sharepoint list as query in excel
When I tried to export for excel my sharepoint list, and I open the query on excel it shows the follow message as an error:: "There isn't enough memory to complete this action. Try using less data or closing other applications" I tried to…
![](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(3.2, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
0 answers
Excel API can't reach data on the last column XFD
I'm using Excel API to read the header of a vertically small file, but which reaches the Excel column limit going to XFD. Calling both /worksheets('Sheet1')/usedRange(valuesOnly=true) and /worksheets('Sheet1')/range(address='A1:XFD1') endpoints will…
![](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(192, 3%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
How to access a special column in the totals row of a table?
I have the following table for example: NameSalesRegionJohn23WestUwe45WestMary39EastDoris12WestPeter8EastTotal1275The table is named 'myData'. I can access the Totals row by myData[#Totals]. I can access the Sales column by myData[Sales]. But how to…
asked 2024-07-22T10:57:09.32+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, 83%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Regina Henschel
176
Reputation points
commented 2024-07-23T05:54:24.66+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
7,625
Reputation points Microsoft Vendor
1 answer
I want to automatically send emails from Excel spreadsheet based on cell content.
Hi All, I am working with a report to track task. It has all the details from who sent it till whether is completed or not. Multiple users are involved in this who actually send request. I would be the one updating the status as whether is still open or…
asked 2024-07-15T11:35:41.69+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(297.6, 32%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Praveen Kumar Selvaraj
0
Reputation points
edited a comment 2024-07-23T02:46:59.41+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(64, 16%, 16%)' 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)
Joan Hua-MSFT
770
Reputation points Microsoft Vendor
1 answer
Richedit errors when opening SharePoint files.
I'm the farm admin for a SharePoint 2019 on-prem installation. We are using Office 365 for our Word and Excel apps. Recently users have been getting error messages when trying to open files from SharePoint. The message box has 'Richedit' in the corner,…
asked 2024-07-22T16:38:08.67+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(272, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Keith Vollero
21
Reputation points
answered 2024-07-23T02:38:09.2766667+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(252.8, 5%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RaytheonXie_MSFT
33,641
Reputation points Microsoft Vendor
1 answer
problema Microsoft.ACE.OLEDB.12.0
estoy queriendo importar una base de datos que tengo en Excel a sql server managment studio 20 y me tira el error "Microsoft.ACE.OLEDB.12.0" ya intente descargandome esto Microsoft Access Database Engine 2016 Redistributable pero no funciona…
asked 2024-07-22T21:53:29.64+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(185.6, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFL%3C/text%3E%3C/svg%3E)
felix lewis
0
Reputation points
commented 2024-07-23T02:00:20.8233333+00:00
LiHongMSFT-4306
25,651
Reputation points
3 answers
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
![](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(60.8, 25%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ3%3C/text%3E%3C/svg%3E)
![](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(272, 12%, 36%)' 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)
1 answer
One of the answers was accepted by the question author.
Insert Form into an Excel in a Teams Private Channel SharePoint
When I create Excel files and open them in SharePoint, I am able to Insert > Forms > New Form. However, I just created a Private Channel in Teams, opened its SharePoint and created a new Excel file. When I open this Excel file, when I do Insert…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,606 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,273 questions
![](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(307.2, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
Why does DATEDIF give different results in Excel and SharePoint?
The following formula gives different results in an Excel worksheet and a SharePoint list: =DateDif([Date_1],[Date_2],"md") There are ten cases where Excel gives a higher number than Sharepoint, and two cases where SharePoint gives a higher…
asked 2024-07-02T11:15:45.3633333+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(185.6, 43%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Remster
0
Reputation points
commented 2024-07-22T07:23:57.9533333+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(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
44,151
Reputation points Microsoft Vendor
1 answer
Can I retain formula results if background data changes?
To Note I tried like 30 times to post this in the Excel Forums and keep getting some random error. I have a workbook with lets say 4 sheets. A-Coversheet B-Requirements Tracker C-Services D-Software Sheets A, C, and D have rows…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 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,715 questions
asked 2024-07-11T20:27:21.42+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(185.6, 87%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jeanne Meadows
0
Reputation points
commented 2024-07-22T07:08:44.99+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
2 answers
How can I convert hours in time format to days in decimal format
Hello I run a table in excel to calculate the hours I work for each client. I enter the start and end time in format hh:mm. This calculates the number of hours worked on that project each day into a total which is formatted in the cell as Time. This…
asked 2024-07-18T21:58:01.5233333+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, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sonja Porter
0
Reputation points
commented 2024-07-22T07:05:16.9033333+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
2 answers
Excel online share to other user can edit but can't download
Hi team, My friend using OneDrive Enterprise and he wants to share Excel online files with users that they can edit but can't download. Now "block download" option is missing. he said it appeared when he granted edit access to users. could you…
asked 2024-07-18T12:32:00.8666667+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, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECU%3C/text%3E%3C/svg%3E)
Chanwut Upokin
0
Reputation points
commented 2024-07-22T07:04:07.52+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
Excel charts not displayed correctly on different computers
When I opened an Excel document with charts on my Windows 10 computer, the charts displayed normally. However, when I or my colleagues opened the document on another computer or even on my phone, the charts were not displayed correctly. Specifically, the…
asked 2024-07-18T00:38:01.8833333+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(105.60000000000001, 91%, 20%)' 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)
悦萌 牛
0
Reputation points
commented 2024-07-22T06:59:15.61+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
How to get AutoSave to save to the correct file path rather than a default file location on OneDrive.
AutoSave had been working fine until recently. Now when I open an Excel document, AutoSave is turned off. When I turn on AutoSave, it saves a duplicate to the "default local file location" which is [OneDrive/Documents]. When I change the…
asked 2024-07-16T16:55:21.8+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(89.60000000000001, 80%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Joe Studer
0
Reputation points
commented 2024-07-22T06:37:22.85+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
2 answers
làm thế nào sửa lỗi 6d066ec1-e2a0-4f36-af93-5d98e6d59ed3 ạ
dạo này mình đăng nhập office 365 bằng tài khoản trường học thì luôn xuất hiện lỗi như vậy. Làm thế nào để khắc phục ạ
asked 2024-07-14T09:29:33.4066667+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, 12%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nguyen Khanh Linh
0
Reputation points
commented 2024-07-22T06:23:23.7+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
Pasting & Linking in Word
I am currently trying to paste and link into Word from Excel. I am choosing to keep source formatting, but every time I paste, there are extra spaces in some of the cells with numbers. I have too many tables to paste over to delete all the extra spaces.…
asked 2024-07-12T17:56:49.3766667+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(54.400000000000006, 76%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kayla
0
Reputation points
commented 2024-07-22T06:20:05.5766667+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor
1 answer
When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?
I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.
asked 2024-07-04T21:01:09.3766667+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(288, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nathanael Andrade
0
Reputation points
edited a comment 2024-07-22T06:14:52.5733333+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
asked 2024-07-11T07:30:33.8266667+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(233.6, 99%, 32%)' 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)
slardar22
0
Reputation points
commented 2024-07-22T06:11:57.33+00:00
Jiajing Hua-MFST
7,625
Reputation points Microsoft Vendor