|
|
Do you have a slow-to-open ProMax file with embedded Excel? (by Craig Spears)
|
Location: Blogs The BR&E Blog |
 |
| Posted by: BRE Blogger |
Monday, February 06, 2012 1:14 PM |
If a ProMax file with an embedded Excel sheet is excessively slow to open, it may be caused by a tool from Microsoft that validates Excel files during loading. This delay due to validation has been documented to increase file loading times from a few seconds to several minutes for files with large amounts of data, charts, and/or cell comments. The longest validation delays appear to occur with files stored on a network location, as opposed to a local directory on the computer.
To verify that you have the tool installed, you may go to your Control Panel, and select “Add/Remove Programs” if you are using Windows XP, or select “Uninstall a program” if you are using Windows 7. Look for the “Microsoft Office File Validation Add-In”, as shown below.
Excel 2010 has the validation tool built-in to the program. If you are using Excel 2010, information on controlling or disabling the Office File Validation tool can be found here: http://blogs.technet.com/b/office2010/archive/2009/12/16/office-2010-file-validation.aspx. The settings for disabling the tool and preventing failed documents from being sent to Microsoft are only available at a group-policy level, available to administrators of the GPOs for your organization. However, information on editing user registry settings are available in the above link.
|
|
| Permalink |
Trackback |
|
|
|
|
|