1,668 questions with Excel tags

Sort by: Updated
6 answers One of the answers was accepted by the question author.

Data from a csv file to excel, date is in MM/DD/YYYY format, region set as Australia

Newbie here so simple language please. Data was transferred as a csv file into excel file. I have subsequently entered more data. I have noticed the date of the imported data is in MM/DD/YYYY format even though settings, region, language and cell format…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2024-06-18T06:28:41.07+00:00
Body and Sole Podiatry 20 Reputation points
answered 2024-07-13T07:46:49.47+00:00
Body and Sole Podiatry 20 Reputation points
0 answers

Random 404 responses to ExecuteRichApiRequest http POST requests

How can I prevent frequent 404 responses to a Post request to "ExecuteRichApiRequest" (https://usc-excel.officeapps.live.com/x/_vti_bin/EwaInternalWebService.json/ExecuteRichApiRequest?waccluster=US1 ) in my JavaScript API-built excel add-on?…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
934 questions
asked 2024-07-12T18:43:23.81+00:00
Justin Fitch 0 Reputation points
edited the question 2024-07-13T00:19:28.0766667+00:00
Justin Fitch 0 Reputation points
0 answers

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,668 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
934 questions
asked 2024-07-12T20:44:26.7333333+00:00
Nestor Herrera 0 Reputation points
0 answers

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.…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
743 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2024-07-12T17:56:49.3766667+00:00
Kayla 0 Reputation points
2 answers

"An operation that uses the database driver could not be completed. 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."

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 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,686 questions
asked 2023-10-25T20:03:28.8633333+00:00
zubaid ahmed 0 Reputation points
commented 2024-07-12T13:19:50.5766667+00:00
Goede, Rhonda 0 Reputation points
1 answer

Glitches in Excel formulas

02.07.24 Fd Wge Cost Bgt 24-25 - 10 (version 8 13.05.24.xml Hi, We have a problem with the attached spreadsheet. The details are as follows: Daily Spreadsheet : "Monday" Wages Q2985 "Minimum" formula for Mondays only works with…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2024-07-04T10:29:18.0633333+00:00
Laurence Clerkin 0 Reputation points
commented 2024-07-12T07:45:32.88+00:00
Jiajing Hua-MFST 7,545 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,668 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,694 questions
asked 2024-07-11T20:27:21.42+00:00
Jeanne Meadows 0 Reputation points
edited the question 2024-07-12T06:22:12.1433333+00:00
Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor
1 answer

how to combine all sheets in power query

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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,686 questions
Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
673 questions
asked 2024-07-11T07:30:33.8266667+00:00
slardar22 0 Reputation points
edited a comment 2024-07-12T02:05:15.19+00:00
Jiajing Hua-MFST 7,545 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Python Function limit chars?

I was super excited to see Python was being supported in MS Excel. I have been waiting for this functionality for a very long time. I was pretty sad to see the limitation of only 8,415 characters per python script. Is there any way to increase this? I…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2024-07-10T16:30:26.4666667+00:00
Robert 20 Reputation points
accepted 2024-07-11T12:36:36.19+00:00
Robert 20 Reputation points
0 answers

Help with "DataPivotHierarchy setSummarizeBy: The argument is invalid or missing or has an incorrect format." error

I have an excel script which used to run with no problems. Suddenly I'am getting an error when trying to set a column to summarise by average in a pivot table. I get the following error: DataPivotHierarchy setSummarizeBy: The argument is invalid or…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,447 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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,694 questions
asked 2024-07-11T05:26:39.35+00:00
Felipe Leefu Huang Lin 0 Reputation points
edited the question 2024-07-11T07:26:06.5166667+00:00
Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor
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…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
asked 2024-07-02T11:15:45.3633333+00:00
Remster 0 Reputation points
commented 2024-07-11T01:34:11.83+00:00
Haoyan Xue_MSFT 21,996 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Conditional formatting for a column based on the contents of another column

I am trying to format font and/or background for the cells in one column based on the content of the associated cell in another column. I can get it to work if I do it cell by cell but have no desire to set of the conditions individually for each cell. …

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,447 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2024-07-08T16:15:30.9666667+00:00
Karla Marciszewski 20 Reputation points
commented 2024-07-10T18:02:09.7533333+00:00
Karla Marciszewski 20 Reputation points
1 answer

why Excel VBA modules are not getting saved?

Hello All, I am working on development of a project specific excel tool and I am stuck on one issue.   I am facing an issue in saving the modules which I create in Visual Basics Window. The modules gets discarded every time I close the excel and reopen…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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,694 questions
asked 2023-03-24T06:08:46.1733333+00:00
Medha Nandkishor Goley 5 Reputation points
edited a comment 2024-07-10T10:07:23.1533333+00:00
Louis du Preez 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,545 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
asked 2024-07-07T15:54:13.5166667+00:00
Vivek 0 Reputation points
commented 2024-07-10T06:31:14.3733333+00:00
Yanli Jiang - MSFT 23,581 Reputation points Microsoft Vendor
0 answers

I need a simple and elegant solution to export a detailed audit of all changes to an Excel Online file.

What I'm looking for is a report that shows the same format as the legacy "Track Changes" function, but in a modern environment. I believe the best way would be to aggregate all of the changes that are listed by the "track changes"…

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,275 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
934 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,694 questions
asked 2024-07-09T22:54:39.3033333+00:00
Mark George 0 Reputation points
edited the question 2024-07-10T05:50:07.79+00:00
Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor
2 answers

New Excel workbooks (created in SharePoint library) not launching in app - .xlsx "extension is not valid"

Hi there,   Having a recent issue in some SharePoint sites - in Document Libraries, using the (default) New > Excel Workbook action gives the error when launching the app: "Excel cannot open the file 'Book.xlsx' because the file format or file…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
asked 2024-04-16T01:29:14.2533333+00:00
Alan NZ 45 Reputation points
answered 2024-07-09T20:10:55.71+00:00
Marie, D 0 Reputation points
4 answers

How do I fix microsoft office error message "The operating system is not presently configured to run this application" I'm getting it for Excel and Outlook

Problem started today and neither Outlook nor Excel will open up.

Outlook
Outlook
A family of Microsoft email and calendar products.
3,370 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2023-09-20T18:13:15.3733333+00:00
Susan 10 Reputation points
answered 2024-07-09T15:01:01.96+00:00
kareem kamal 0 Reputation points
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,370 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.
250 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
asked 2024-07-09T05:44:33.5666667+00:00
Kumar, P. ab 0 Reputation points
answered 2024-07-09T07:35:28.7366667+00:00
SokiGuo-MSFT 25,651 Reputation points Microsoft Vendor
0 answers

dynamic add label to userform and click event

I want to dynamically add multiple labels to a userform and then capture the click event to run a macro based on the name of the label. I figured out how to add the labels but not the click event. Thank you in advance. :-)

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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,694 questions
asked 2024-07-08T18:49:35.2366667+00:00
Vayder, Dean 0 Reputation points
edited the question 2024-07-09T05:43:01.91+00:00
Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor
0 answers

microsoft visio viewer was not able to complete the operation - vba in excel

I am using the Visio Viewer Active X control in excel. When I try using the following method I get the message "microsoft visio viewer was not able to complete the operation" Sheet1.ViewerSMG.Load…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 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,694 questions
Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
251 questions
asked 2024-07-04T16:02:04.78+00:00
stewart graham 0 Reputation points
commented 2024-07-08T17:19:25.7866667+00:00
Viorel 114.4K Reputation points