Excel Management

1 answer

Are you able to create a note in the web version of Excel?

Good morning, I encountered an issue where I was unable to create a note for a cell in the web version of Excel. I am able to create a note in the local application version. I wanted to see if this was a know limitation of the web version of Excel? …

asked

Jonathan Martin 1

commented

Emily Hua-MSFT 27,576

0 answers

Opening files in protected view crashes office application

We have had issues where if you open files (for us it was .csv files) in Protected View/Mode in Office 365, the application would hang/crash. We found a solution at least for Office 365 or M365 Apps. Build 1908 crashes but when we upgrade to 2002,…

asked

RJames2010 36

commented

Emily Hua-MSFT 27,576

2 answers

Help with Excel Formula incrementing.

I am trying to make an Excel form to track progress of a construction project. I want to be able to use the file for future projects, but not have to input the formulas by hand every time. When I drag the formula it increments like normal, but when I…

asked

Wesley Goodwin 21

accepted

Wesley Goodwin 21

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…

asked

Sam Savage 1

commented

Itch Sun-MSFT 2,556

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…

asked

Teodoro D'Angelo 1

commented

Itch Sun-MSFT 2,556

1 answer

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…

asked

Envisliberty 21

commented

Envisliberty 21

2 answers

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…

asked

shashi shetty 21

commented

shashi shetty 21

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…

asked

Andres Rotman 1

commented

Emily Hua-MSFT 27,576

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…

asked

TF123321 1

commented

Itch Sun-MSFT 2,556

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…

asked

Aaron Harris 1

commented

Emily Hua-MSFT 27,576

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…

asked

UBajwa 1

answered

Emily Hua-MSFT 27,576

2 answers

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

asked

Ian3 66

accepted

Ian3 66

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…

asked

Spookyest 1

commented

Emily Hua-MSFT 27,576

3 answers

Saving issue

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

asked

Harshavardhan Reddy 1

commented

Emily Hua-MSFT 27,576

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…

asked

Michael - Work 1

commented

Michael - Work 1

1 answer

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…

asked

CHEN Kwok Cheng 21

accepted

CHEN Kwok Cheng 21

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…

asked

Vivienne Haig 1

commented

Emi Zhang-MSFT 23,271 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…

asked

Kinan Akel 1

answered

Charles Kenyon 2,781

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…

asked

Alfredo Izaguirre Castro 1

commented

Emi Zhang-MSFT 23,271 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…

asked

Hemanth Subbanna 1

commented

Emi Zhang-MSFT 23,271 Microsoft Vendor

Filter

Content

1,684 questions with Excel Management tags

Are you able to create a note in the web version of Excel?

Opening files in protected view crashes office application

Help with Excel Formula incrementing.

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

Problem with solver

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

2 different formulas in a single cell

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

Excel 2016 Corrupting/1 user/Citrix Server environment

Excel file is saving printer settings

Microsoft Excel Performance Issues on SPX with Add ON's

Ask for saving xlsm file

Excel power query data update

Saving issue

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

External Data Refresh Failed on Web Excel Version

#VALUE! Error message

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

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

Microsoft Excel 2016 hangs