Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Excel Could Not Save All the Data and Formatting" | Excel Worksheet Functions |