Hi All,

When saving an 11 MB Excel document as a webpage it takes about 10 mins and it locks up the users pc during the process. Is there a way to compress the Excel document to speed up the convert process. Also the document Excel document has about 15 sheets. Thanks in advance!

Chris

Hi Chris,

Could you tell me the system requirements of your computer and the version of your Office?

Did your excel file contain any Macros or formulas?

Did this issue only appear in this 11MB particular file?

Where did you store the excel file, local computer or network?

I suggest you turn off automatic calculation function in Excel.

If your excel file stored in network, I suggest you try to disable Office File Validation, please go to:

HKEY_CURRENT_USER\Software\Microsoft\Office\1X.0\Excel\Options

Look for a DWORD value labeled DisableRobustifiedUNC set to a value of 1. If this is set on your machine, it's recommended you delete this value or set the DWORD value to 0.

Important Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
Please refer to this article about how to back up and restore the registry in Windows:
https://support.microsoft.com/en-us/kb/322756?wa=wsignin1.0

Please try this method and check if it works for you.

Any updates please let me know, I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Hi All,

When saving an 11 MB Excel document as a webpage it takes about 10 mins and it locks up the users pc during the process. Is there a way to compress the Excel document to speed up the convert process. Also the document Excel document has about 15 sheets. Thanks in advance!

Chris

• Merged by Emi Zhang CHNMicrosoft contingent staff, Moderator 1 hour 29 minutes ago same title

Hi All,

When saving an 11 MB Excel document as a webpage it takes about 10 mins and it locks up the users pc during the process. Is there a way to compress the Excel document to speed up the convert process. Also the document Excel document has about 15 sheets. Thanks in advance!

Chris

• Merged by Emi Zhang CHNMicrosoft contingent staff, Moderator Tuesday, September 01, 2015 6:02 AM same title

Hi All,

When saving an 11 MB Excel document as a webpage it takes about 10 mins and it locks up the users pc during the process. Is there a way to compress the Excel document to speed up the convert process. Also the document Excel document has about 15 sheets. Thanks in advance!

Chris

• Merged by Emi Zhang CHNMicrosoft contingent staff, Moderator Tuesday, September 01, 2015 6:02 AM same title

Hi Emi,

The system specs of the pc are... Dell Optiplex - Intel i5 @ 3.30 Ghz - 4 GB of RAM.

Microsoft Office Professional Plus 2010 - 14.0.6029.1000

The 11 MB file in question is the only file that they perform this function on.

The file is stored on the network but I tried copying it to my local C drive and perform the same process and it took just as long.

It does not contain macros or formulas from memory.

I shall try to turn off the automatic calculation function in Excel and I shall report back.

Thanks again for your assistance

Chris

Hi Chris,

If possible, you can share the file to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

This is a safe email address and only use to collect information from users, I'm glad to help you.

Regards,

Emi Zhang
TechNet Community Su

Hi Emi,

I spoke to the owner of the excel spreadsheet and they are not willing to provide a copy of the file due to the business sensitive data that is contains. Thanks for your help thus far and if you have any more suggestions of what I can try that would be great. Thanks

Chris

Hi,

Save the file in this format Microsoft Excel Binary Worksheet (.xlsb) and after save as a webpage.