1,681 questions with Excel tags

Sort by: Updated
2 answers

Office Script to delete all rows in a table receives timeout error

I have an office script that is designed to delete all rows in a table. When I run it for 50 or less rows it runs with no problem, but times out when I test it for a larger number of rows (~600). Once this project is live I anticipate the table will…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 questions
asked 2024-05-16T14:08:07.1333333+00:00
Wewillendure 0 Reputation points
answered 2024-07-19T15:47:59.47+00:00
Wewillendure 0 Reputation points
1 answer

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,583 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 questions
asked 2024-07-07T15:54:13.5166667+00:00
Vivek 0 Reputation points
commented 2024-07-19T09:02:09.0733333+00:00
Ling Zhou_MSFT 15,320 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-18T12:32:00.8666667+00:00
Chanwut Upokin 0 Reputation points
answered 2024-07-19T05:58:54.3+00:00
Jiajing Hua-MFST 7,625 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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-18T21:58:01.5233333+00:00
Sonja Porter 0 Reputation points
answered 2024-07-19T02:06:09.5933333+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
0 answers

The insertWorksheetsFromBase64() Excel api is missing capability to insert hidden worksheets

Currently we are utilizing  insertWorksheetsFromBase64() api for our plugin to insert worksheets into excel workbook. Our team would like to insert HIDDEN worksheets using insertWorksheetsFromBase64() Excel api. Is it feasible from your end to expose…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,459 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 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,689 questions
asked 2024-07-18T20:49:58.24+00:00
Tashpulatov, Azizbek 0 Reputation points
edited the question 2024-07-19T01:37:14.3466667+00:00
Emi Zhang-MSFT 23,736 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…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,403 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-15T11:35:41.69+00:00
Praveen Kumar Selvaraj 0 Reputation points
commented 2024-07-19T01:28:58.1633333+00:00
Joan Hua-MSFT 765 Reputation points Microsoft Vendor
0 answers

How to fix "an operation that uses the driver could noet be compleated. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query." while using Inventory Cube in Escel

Hello, We're trying to troubleshoot the error that is occurring for one of our user's when he tries to run Inventory Cube within Excel. We've already tried reinstalling Office, running Excel in safe mode, changed the settings in order to unblock DDE,…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-02T12:56:05.92+00:00
Suchecki, Jan 0 Reputation points
commented 2024-07-18T13:27:05.3933333+00:00
Suchecki, Jan 0 Reputation points
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-18T00:38:01.8833333+00:00
悦萌 牛 0 Reputation points
answered 2024-07-18T05:48:05.3366667+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
0 answers

Can i add another value in this PivotFilter statement?

Hi, Can i add another value (e.g. TLOG_MMF_COR_0003) in the below statement 'Type:=xlCaptionDoesNotBeginWith' where existing value1 'ATLOG_MMF_0003' is there already: ============================================ …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 questions
asked 2024-07-17T19:28:50.9833333+00:00
Ruiz Nelli 20 Reputation points
edited the question 2024-07-18T05:27:37.7133333+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

Excel close and reopen - Faulting module name: mso20win32client.dll

Hi, on some computers in my company Excel sometimes closes and reopens without presenting any error messages. Sometimes changes to the file are preserved and sometimes they are lost. Our Excel is part of Microsoft 365 Business standard. These computers…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-17T08:00:18.2666667+00:00
Jean-Philippe Rollandoz 0 Reputation points
answered 2024-07-18T03:59:39.3433333+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
2 answers

How to fix SSMS import excel issue for Dell/Windows?

Hi, Im starting to learn how to code in SQL and want to start creating my own projects. Im trying to import my own excel file (64 bit) to the SSMS server but am unable to do so because of this image in the attached. Can anyone help with a solution to…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,318 questions
asked 2024-07-17T13:35:41.4566667+00:00
Zach Masessa 0 Reputation points
commented 2024-07-18T01:27:48.94+00:00
LiHongMSFT-4306 25,651 Reputation points
0 answers

Problems with VBA

This will look for current year and month folder problem one is it keeps cresting the 2 folders over and over again, Also would like for it to save the file with the value of a cell like if I put address in it would save in the current month file with…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 questions
asked 2024-07-17T09:35:19.11+00:00
James Barber 0 Reputation points
edited the question 2024-07-18T01:26:55.44+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
4 answers

Need to stop office apps from EVER opening in a browser on my PC. Was told to post here by answers.microsoft

I need to stop files (Excel files on SharePoint/OneDrive primarily) from opening in a browser on my PC. I feel like I've tried everything. All the advice I get is to click on the ellipses and select "open in desktop app", or go to SharePoint…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
963 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 questions
asked 2024-03-12T14:25:38.0033333+00:00
Patrick Ldierts 5 Reputation points
answered 2024-07-17T14:20:44.7166667+00:00
Jesse H 0 Reputation points
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…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,324 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-16T16:55:21.8+00:00
Joe Studer 0 Reputation points
answered 2024-07-17T06:10:10.07+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
0 answers

VBA codes using Named Ranges is not working since migration to O365

We recently migrated to O365 and we have several spreadsheets that are legacy items that transpose information from one sheet to another (info from input sheet to a table that is on another sheet for upload and is reconfigured to a different format) . …

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 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,709 questions
asked 2024-07-16T14:28:43.7766667+00:00
Jennifer Ford 0 Reputation points
edited the question 2024-07-17T01:34:36.55+00:00
Emi Zhang-MSFT 23,736 Reputation points Microsoft Vendor
1 answer

System.ArgumentException: Value does not fall within the expected range.

I am making an Excel Addin in C# in Visual Studio. I have already made another simpler Addin and installed it with no problem. But on this one I am getting the following error: “Name: ExcelAddin_RSMeansV.2 From: file:///C:/Users/jstebbins/Desktop/Excel…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,625 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,709 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
606 questions
asked 2023-12-05T03:02:02.8933333+00:00
Joshua S 5 Reputation points
answered 2024-07-16T17:24:06.3666667+00:00
Waqar Kabir 1 Reputation point
1 answer

An issue with the data model is preventing Microsoft Excel from launching workbook

Hi Friday I worked in one of my Excel folders that are running with queries and connections (Data Model) My sheet worked perfectly on Friday and when I returned today to the office and want to refresh my data I got the message that an issue with the data…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-16T04:12:32.4333333+00:00
Accounting 0 Reputation points
answered 2024-07-16T07:56:05.2633333+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

Excel/Powerpoint send as attachment feature not working correctly in new Outlook

When sending emails from excel/powerpoint as attachment, the email doesn't get delivered to user in new outlook. The same can be done in old outlook.

Outlook
Outlook
A family of Microsoft email and calendar products.
3,403 questions
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
251 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-09T05:44:33.5666667+00:00
Kumar, P. ab 0 Reputation points
commented 2024-07-16T05:05:08.6833333+00:00
SokiGuo-MSFT 25,741 Reputation points Microsoft Vendor
1 answer

Excel SCRIPT not running in P.automate

A P.automate flow uses an Excel script to create a chart but the line where Getpoints is used causes an error in online execution. Desktop script execution works w-o…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
937 questions
asked 2024-07-12T20:44:26.7333333+00:00
Nestor Herrera 0 Reputation points
answered 2024-07-15T12:08:11.1566667+00:00
Claudia Dos Santos Haz (CONCENTRIX CORPORATION) 1,010 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 ạ

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,324 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
asked 2024-07-14T09:29:33.4066667+00:00
Nguyen Khanh Linh 0 Reputation points
answered 2024-07-15T06:36:31.5166667+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor