Issue:
MS XML formatted spreadsheets crash during import or resorts when opening in MS Excel 2010.
These files open and manipulate just fine in earlier versions of Excel back to 2003.
Solution:
As reverting back is not desired, look for few things:
1. Built up Maps. Excel keeps creating new map files each time, these can build up and cause issues. Delete them.
Sample delete code:
Dim XmlMap as XmlMap
For Each XmlMap In ActiveWorkbook.XmlMaps
XmlMap.Delete
Next
2. Look for an invalid character around the crash point, if you were lucky enough to get a good log file.
3. If the error involves "Excel cannot complete the task" and "available resources" , you've hit a memory wall.
4. If you cannot open it because "File is corrupt and cannot be opened" (but it opens just fine if copied to a 2007 Excel machine), then try turning off the Trust Center. It's the new security settings section that protects you from your files.
1. File --> Options
2. Trust Center --> Trust center settings
3. Select Protected view, and uncheck the options, and click OK.
4. Restart Excel and see if it works.
5. After you open the file successfully, save it in the new 2010 format. Then go back and turn on your security so you are better protected again from your files.
If it does, you can create a "trusted location" somewhere, and then download to that location first.
Alternately, you can download/save as a file. Then right-click open in IE, and re-save from IE. This will make the file "trusted".
Alternately, you can change your IE settings, to make sure that the site(s) you download your are Trusted sites (like your Intranet). That way the files will not flagged as unsafe to start with.
(Of course, be careful doing this for any public web sites.)
Resorts can crash you with Excel 2010:
http://social.technet.microsoft.com/Forums/en-US/excel/thread/12e1d44c-4379-4e8c-92ec-b8f63a32e08a
- Could be printer driver - update printer drivers
- Update Excel to newest release. Run repair.
- Use Excel Safe mode, so printer driver won't load
- Disable all add-ins (although in these two links, the users had already tried this).
http://social.technet.microsoft.com/Forums/en-GB/excel/thread/6e160af9-1d0a-49c7-ac2a-98c91f2873ce
- Try running in safe mode.
- Not MS Excel problem, call your printer vendor.
previous page
|