Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility error when saving file.
I have a WB created in Excel 2003. When I open and save the file in 2007 in
the same mode it was opened, I get the following error: This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. Here is a sample of the cells it says are bad: 'Budget Template'!G13:G25 'Budget Template'!G30:G159 These two regions of the column are in the unlocked portion of my worksheets. The sheets are protected. All other sheets were copied from this template sheet and are listed also with the same regions. So I assume the template file is the origin of the error for all the sheets. Why is this being flagged as an error and how do I clear it? Thanks, John S. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility error when saving file.
Do those ranges have formulas, or are they for input only?
-- If this helps, please click "Yes" <<<<<<<<<<<< "DocBrown" wrote: I have a WB created in Excel 2003. When I open and save the file in 2007 in the same mode it was opened, I get the following error: This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. Here is a sample of the cells it says are bad: 'Budget Template'!G13:G25 'Budget Template'!G30:G159 These two regions of the column are in the unlocked portion of my worksheets. The sheets are protected. All other sheets were copied from this template sheet and are listed also with the same regions. So I assume the template file is the origin of the error for all the sheets. Why is this being flagged as an error and how do I clear it? Thanks, John S. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility error when saving file.
Those ranges are for input only. I have other columns adjacent to these that
also are for input, but they don't seem to be causing this error. John S "BSc Chem Eng Rick" wrote: Do those ranges have formulas, or are they for input only? -- If this helps, please click "Yes" <<<<<<<<<<<< "DocBrown" wrote: I have a WB created in Excel 2003. When I open and save the file in 2007 in the same mode it was opened, I get the following error: This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. Here is a sample of the cells it says are bad: 'Budget Template'!G13:G25 'Budget Template'!G30:G159 These two regions of the column are in the unlocked portion of my worksheets. The sheets are protected. All other sheets were copied from this template sheet and are listed also with the same regions. So I assume the template file is the origin of the error for all the sheets. Why is this being flagged as an error and how do I clear it? Thanks, John S. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility error when saving file.
Try unprotecting the sheet, saving it in the required format and then
reprotecting it and saving again. If this helps, please click "Yes" <<<<<<<<<<<< "DocBrown" wrote: Those ranges are for input only. I have other columns adjacent to these that also are for input, but they don't seem to be causing this error. John S "BSc Chem Eng Rick" wrote: Do those ranges have formulas, or are they for input only? -- If this helps, please click "Yes" <<<<<<<<<<<< "DocBrown" wrote: I have a WB created in Excel 2003. When I open and save the file in 2007 in the same mode it was opened, I get the following error: This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. Here is a sample of the cells it says are bad: 'Budget Template'!G13:G25 'Budget Template'!G30:G159 These two regions of the column are in the unlocked portion of my worksheets. The sheets are protected. All other sheets were copied from this template sheet and are listed also with the same regions. So I assume the template file is the origin of the error for all the sheets. Why is this being flagged as an error and how do I clear it? Thanks, John S. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility error when saving file.
Doc,
I've just encountered your problem. Here's how I fixed it. Save the workbook in the 2007 format (you will notice the title bar still reads "[Compatability Mode]"). Now close the workbook and reopen (title bar no longer reads "[Compatability Mode]"). Try out your formulas, they should work. If this helps, please click "Yes" <<<<<<<<<<< "DocBrown" wrote: Those ranges are for input only. I have other columns adjacent to these that also are for input, but they don't seem to be causing this error. John S "BSc Chem Eng Rick" wrote: Do those ranges have formulas, or are they for input only? -- If this helps, please click "Yes" <<<<<<<<<<<< "DocBrown" wrote: I have a WB created in Excel 2003. When I open and save the file in 2007 in the same mode it was opened, I get the following error: This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. Here is a sample of the cells it says are bad: 'Budget Template'!G13:G25 'Budget Template'!G30:G159 These two regions of the column are in the unlocked portion of my worksheets. The sheets are protected. All other sheets were copied from this template sheet and are listed also with the same regions. So I assume the template file is the origin of the error for all the sheets. Why is this being flagged as an error and how do I clear it? Thanks, John S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Updated to Office 2007 - Saving Excel file error | Excel Discussion (Misc queries) | |||
Saving in Compatibility mode | Excel Discussion (Misc queries) | |||
error saving a new file on server | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) |