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?
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 DiagnosticsRunning 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 & RepairEDIT ADDED:
You could also try running with manual Calc.
Set Excel to manual Calc mode first,
then open the file via File > Open