I have a fairly large spreadsheet (~20,000 rows, 26.8M file size). Most of
the occupied cells contain VLOOKUP formulas that reference different
workbook. When I close this workbook, I get the message "Excel could not
save all the data and formatting you recently added to FILENAME.xls", where
"FILENAME.xls" is the file name of the workbook in question. If I select
the option "Continue saving changes without repairing the problem", the
spreadsheet appears to save OK. If I close the spreadsheet and later
re-open it, I cannot identify any problems or lost data or formatting.

Does anyone have any idea what causes this message, and what I am loosing?

Thanks,

-- David

Yes please someone help. I am getting the same message with 2 large files
with tons of Vlookups, Conditional Formatting, and Data Validations. I am
noticing I am losing my changes to the Data Validation. I thought I was
losing my mind because I swore I had put in all the DV before but I just did
it again and saved and nothing. I have wasted hours of work, not realizing
it wasnt saving. Let me know if you hear anything.

"David Benson" wrote:

I have a fairly large spreadsheet (~20,000 rows, 26.8M file size). Most of
the occupied cells contain VLOOKUP formulas that reference different
workbook. When I close this workbook, I get the message "Excel could not
save all the data and formatting you recently added to FILENAME.xls", where
"FILENAME.xls" is the file name of the workbook in question. If I select
the option "Continue saving changes without repairing the problem", the
spreadsheet appears to save OK. If I close the spreadsheet and later
re-open it, I cannot identify any problems or lost data or formatting.

Does anyone have any idea what causes this message, and what I am loosing?

Thanks,

-- David