Unable to open large Excel file

August 7, 2012 at 12:27:29
Specs: Windows XP
User is able to generate report from Excel when date range is one month, however, when date range is increased unable to open it in Excel. Message indicates: Excel was able to open the file by repairing or removing the unreadable content.
Other users can successfully run and open this same report in Excel for periods up to 1 year. Any thoughts?
Would Temporary File space have any impact?

See More: Unable to open large Excel file

Report •


#1
August 7, 2012 at 12:34:56
What version of Excel?

Try a Diagnostic for 2007:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics


2000 & 2003 try a Detect & Repair:

On the Task Bar
Help
Detect & Repair

EDIT ADDED:
You could also try running with manual Calc.
Set Excel to manual Calc mode first,
then open the file via File > Open

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question