Thanks for the response Joel. I tried doing what you told me and the new
workbook also crashed when I tried to save it.

Do you know what the problem might be with the web queries and how I can
find it? They are just simple queries that pull tables off a website. Why
would excel not be able to save a file because of that? They are not queries
that are supposed to auto-refresh.

Shishir

"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