I
infpguy
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I've got a workbook that has a sheet I'd like to save as a webpage for sharing a report. However, every time I attempt to save the sheet as a webpage Excel crashes, throws the crash reporting dialog, and then restarts.
The workbook is a ".xlsx" format file (the .xlsb format has proven to be so unstable as to be unusable with constant crashes.). There are 16 worksheets with a about 2-3 thousand raw data cells and another 2-3 thousand formula cells. The sheet in question contains a 10 cell x 36 cell summary of data input sheet. The "summary" uses a date method to perform lookups into the data input sheet for the data elements to display (most cells in the summary contain "indirect(address(...))" like functions. The summary cells also have a conditional formatting rule that colors the columns to identify weekend days. This data is then used for a series of 6 charts that are displayed in the worksheet's "page 2".
As a result of the crash there is no output files, html or otherwise (haven't tried looking for hidden or temp files).
Any ideas on what could be causing the crash and if there is a workaround.
Oh, and before anyone asks... no I can't share the workbook as the data is proprietary. If it really matters, I can try to work up an alternative with junk data that does the same work.
The workbook is a ".xlsx" format file (the .xlsb format has proven to be so unstable as to be unusable with constant crashes.). There are 16 worksheets with a about 2-3 thousand raw data cells and another 2-3 thousand formula cells. The sheet in question contains a 10 cell x 36 cell summary of data input sheet. The "summary" uses a date method to perform lookups into the data input sheet for the data elements to display (most cells in the summary contain "indirect(address(...))" like functions. The summary cells also have a conditional formatting rule that colors the columns to identify weekend days. This data is then used for a series of 6 charts that are displayed in the worksheet's "page 2".
As a result of the crash there is no output files, html or otherwise (haven't tried looking for hidden or temp files).
Any ideas on what could be causing the crash and if there is a workaround.
Oh, and before anyone asks... no I can't share the workbook as the data is proprietary. If it really matters, I can try to work up an alternative with junk data that does the same work.