No that's not the case, it's saved as a 2007 file. Any other ideas?

"joel" wrote:

One possibility is there are too many rows being returned. You could have a
XLS file type which limits the number of rows and columns. Try saving the
file using SAVEAS and select a file type other than XLS (one of the newer
2007 types).



"joel" wrote:

I would try making a new workbook the follwing way

1) select all the tabs in the workbook

Select 1st tab and then scroll too last tab (first tabg still selected).
Hold the shift key and press the last tab. All the tabs are now selected.

2) Hold the mouse over any of the selected tabs and press right mouse key

3) Select Copy or move

4) Select Make a copy and then on the pull down (To book) sleect new workbook.

5) Save New workbook using SAVEAS.

This method will force excel to copy the data and eleiminatre any errors
that may be in the workbook. if you get an error using this method then you
workbook has an error that need to be fixed.

Try going to the follwing tool while the workbook is opened.

Start = Programs - Microsoft office - Microsoft Ofice Tools - Moicrtosoft
office Application Recovery

"Shishir" wrote:

Hi,

I'm on Excel 2007 and I have a excel file with quite a few web queries that
pull data from external websites - basically tables of financial data.

After opening the file, I'm able to work with the worksheet well enough and
refresh my data, but whenever I try to save the file or save as or the
auto-recover tries to save the file, excel just crashes. This happens even if
I just open the file and try to save a new version w/o making any changes, it
just doesn't save the file without crashing.

Any ideas what could be a solution?

Thanks,
Shishir