ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2007 Compatibility Checker states cells outside of range when saving2003 version (https://www.excelbanter.com/excel-programming/444800-2007-compatibility-checker-states-cells-outside-range-when-saving2003-version.html)

Michael Lanier

2007 Compatibility Checker states cells outside of range when saving2003 version
 
When saving a 2003 file in 2007, I get a Compatibility Checker message
that states "Workbook contains data outside the row and column limit
of the selected file limit format. Data beyond 256 (IV) columns by
65,536 rows..." I want to delete these formulas to prevent future
messages. Even when I uncheck "Check compatibility when saving this
workbook" I still receive messages. Can you offer a macro that will
delete any formulas that suppossedly outside the Excel 2003 range?
Thanks in advance.


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com