1,641 questions with Excel Management tags

Sort by: Updated
Updated Created Answers
1 answer

Is the Data Table Function broken in Excel 2007 (Build 13029.20344)?

I and my sponsor corporations make heavy use of the Excel Data Table. In 2007 (Build 13029.20344), the calculation time appears to have become roughly 100 times slower. This will disable many applications, and I will need to send out an urgent warning to…

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,641 questions
asked 2020-08-21T06:28:52.703+00:00
Sam Savage 1 Reputation point
commented 2020-08-26T09:35:38.553+00:00
Itch Sun-MSFT 2,556 Reputation points
1 answer

Problem with solver

after downloading the solver, i can't use it because excel tells me: "Microsoft 365 è stato configurato per impedire l'acquisizione di singoli componenti aggiuntivi di Office" Meaning: Microsoft 365 has been configured to prevent the…

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,641 questions
asked 2020-08-12T14:35:11.463+00:00
Teodoro D'Angelo 1 Reputation point
commented 2020-08-24T03:23:05.607+00:00
Itch Sun-MSFT 2,556 Reputation points
1 answer One of the answers was accepted by the question author.

I don't have Microsoft Excel. What's the cause, & What's the solution?

Hi. I've installed "Microsoft Office Pro Plus 2019" a few months ago. It's a really sophisticated suite; but I don't have Microsoft Excel. What's the cause of this problem, and what's the solution? I live in Iran, and you know of the…

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,641 questions
asked 2020-08-22T16:57:32.017+00:00
Envisliberty 21 Reputation points
commented 2020-08-23T14:30:28.943+00:00
Envisliberty 21 Reputation points
2 answers One of the answers was accepted by the question author.

2 different formulas in a single cell

This specifically refers to formulas in the following cells CELL E1 =C1*D1 CELL E2 =1/C2-1 CELL F2 =D2*(1-E2) In 1st row Cell A1 is 1.33times greater than Cell B1 so the Cell D1 has been multiplied 1.33times in Cell E1, In 2nd row Cell A2 is…

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,641 questions
asked 2020-08-19T09:49:39.047+00:00
shashi shetty 21 Reputation points
commented 2020-08-20T11:43:22.74+00:00
shashi shetty 21 Reputation points
1 answer

Problem sharing Excel XLSM files with MACROS between WINDOWS and MAC (Spanish Office 2016)

1) Create a new file XLSM with a MACRO inside name of module in spanish is automatically assigned as "Módulo 1" 2) Take the file, open it in WINDOWS EXCEL. you will see this: 3) If you SAVE on windows side, the file becomes CORRUPT and you…

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
459 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,641 questions
asked 2020-08-12T23:20:35.027+00:00
Andres Rotman 1 Reputation point
commented 2020-08-18T08:17:20.6+00:00
Emily Hua-MSFT 27,526 Reputation points
1 answer

Excel 2016 Corrupting/1 user/Citrix Server environment

Good Afternoon, I was looking to get some guidance if possible, and was directed from Microsoft Answers. I have a citrix server environment set up, and only 1 user experiences their excel documents corrupting after any changes whatsoever. This can be on…

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,641 questions
asked 2020-08-12T20:33:59.507+00:00
TF123321 1 Reputation point
commented 2020-08-18T06:38:38.467+00:00
Itch Sun-MSFT 2,556 Reputation points
0 answers

Excel file is saving printer settings

Excel appears to be saving the printer settings in files edited by one user. Forcing Secure Print to be default on any shared file within the company. I have seen and attempted resolutions below but these are for older versions of Office and did not…

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,641 questions
asked 2020-08-07T18:55:30.397+00:00
Aaron Harris 1 Reputation point
commented 2020-08-13T10:03:07.847+00:00
Emily Hua-MSFT 27,526 Reputation points
1 answer

Microsoft Excel Performance Issues on SPX with Add ON's

Hi there, We recently purchased 13 SPX for our field team and since we have started using Excel with certain business add on's . Excel has been opening and performing very slow. Once we disable the add on, excel works just fine. We have involved…

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,641 questions
asked 2020-08-12T08:41:33.207+00:00
UBajwa 1 Reputation point
answered 2020-08-13T06:47:24.303+00:00
Emily Hua-MSFT 27,526 Reputation points
2 answers One of the answers was accepted by the question author.

Ask for saving xlsm file

When closing an xlsm file, it always asks to save even it is not changed. Is there a way to disable it? Thanks. Ian

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,641 questions
asked 2020-08-02T15:40:48.54+00:00
Ian3 66 Reputation points
accepted 2020-08-11T11:45:16.957+00:00
Ian3 66 Reputation points
2 answers

Excel power query data update

Hi I’ve tried to search for this but seemed to get nowhere. What I’m after is a way to have a master workbook that gets updated from various separate user workbooks. The user workbooks would refresh with the current data but can be updated and…

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,641 questions
asked 2020-08-06T16:39:39.05+00:00
Spookyest 1 Reputation point
commented 2020-08-11T01:01:15.967+00:00
Emily Hua-MSFT 27,526 Reputation points
3 answers

Saving issue

Hi, I want to edit the excel file simultaneously(2 or more members) from file server .

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,641 questions
asked 2020-07-14T12:36:11.927+00:00
Harshavardhan Reddy 1 Reputation point
commented 2020-08-05T05:07:57.367+00:00
Emily Hua-MSFT 27,526 Reputation points
1 answer

Microsoft Office 365 ProPlus - Excel hyperlinks with a pound sign not working

We have an application that creates Excel reports with hyperlinks. We are getting the error, "Unable to open https://xxx.xx.com. Cannot download the information you requested." This seems to be related with a Proxy server and/or the…

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,641 questions
asked 2020-08-02T20:19:41.41+00:00
Michael - Work 1 Reputation point
commented 2020-08-03T17:34:32.49+00:00
Michael - Work 1 Reputation point
1 answer One of the answers was accepted by the question author.

External Data Refresh Failed on Web Excel Version

Hi, I have encounter the refresh issue on web excel version, tried search around but not able to find the right answer to fix. Please help. Error Showing, We were unable to refresh one or more data connections in this workbook. The following…

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,641 questions
asked 2020-07-28T01:54:13.51+00:00
CHEN Kwok Cheng 21 Reputation points
accepted 2020-07-31T01:50:09.443+00:00
CHEN Kwok Cheng 21 Reputation points
1 answer

#VALUE! Error message

I've created a spreadsheet for someone and it works fine on my device. I have emailed it to the client and they are getting a #VALUE! error message in one column. I'm not getting it on my version. They have emailed me the spreadsheet back and I get…

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,641 questions
asked 2020-07-28T11:51:40.24+00:00
Vivienne Haig 1 Reputation point
commented 2020-07-30T00:52:53.09+00:00
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
2 answers

Office Word, Excel, and PowerPoint's Startup Field Value Form

Hi, I recall several years ago, the company I worked at had some templates ready with fields to filled up. At that time, I didn't have to go through File -> Propoerties -> and go to each value and set it. Instead, whenever we opened a new…

Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
893 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,641 questions
asked 2020-07-28T20:27:25.617+00:00
Kinan Akel 1 Reputation point
answered 2020-07-29T22:15:51.627+00:00
Charles Kenyon 2,566 Reputation points
0 answers

Unable to update source data from EXCEL files (PBI table)

When trying to update tables sourced from EXCEL data I got the following error message: OLE DB or ODBC error: Excepción de HRESULT: 0x80040E4E. and it appears to affect the following tables to be updated because for them I got the message that "it…

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,641 questions
asked 2020-07-24T16:18:12.23+00:00
Alfredo Izaguirre Castro 1 Reputation point
commented 2020-07-27T09:14:06.397+00:00
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
1 answer

Microsoft Excel 2016 hangs

I am using MS Office 2016 professional plus . but it keeps hanging , it was giving an ucrtbase.dll error in the event viewer. Then i installed cumulative updates for office 2016 and it worked fine for fer days , but its crashing again now. , I…

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,641 questions
asked 2020-07-24T06:26:49.917+00:00
Hemanth Subbanna 1 Reputation point
commented 2020-07-24T09:24:55.38+00:00
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Excel get Data from other Excel file

I am trying to Pull Data in Excel file saved on my Desktop, from another file saved on Team/SharePoint site. It creates an error message Details: "Access to the resource is forbidden." I can connect to any other Excel file and get Data from…

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,641 questions
asked 2020-07-22T17:00:54.547+00:00
Shailesh P Mehta 41 Reputation points
commented 2020-07-23T13:26:18.153+00:00
Shailesh P Mehta 41 Reputation points
4 answers One of the answers was accepted by the question author.

Support for Visual Studio 2010 Tools for Office Runtime (vstor_redist.exe)

Hi, Could someone confirm if support for Visual Studio 2010 Tools for Office Runtime (vstor_redist.exe) continues? I found information that support for Visual Studio 2010 will be discontinued, and I wonder what's the case regarding VSTO. We have…

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,641 questions
asked 2020-07-22T10:23:45.82+00:00
Katarzyna 21 Reputation points
commented 2020-07-22T13:42:46.843+00:00
Dave Patrick 426.1K Reputation points MVP
1 answer

This workbook contains external data connections or BI features that are not supported.

This workbook contains external data connections or BI features that are not supported.

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,641 questions
asked 2020-07-17T12:51:17.13+00:00
Dilip Kodwani 1 Reputation point
commented 2020-07-20T07:54:18.34+00:00
Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor