I have a template file that I would like 2003 users to be able to open as a .xlsb file that gets converted upon opening.
When the file is opened in 2003 I get a warning message about named ranges and/or ranges going beyond 2003's capabilities but upon checking the ranges there is nothing in the Name Manager list of named ranges that go beyond column IV or row 65536.
Currently the file is saved as a .xls via 2007 and when opened in 2003 I don't get any issues, but if saved as a .xlsb file via 2007, the error messgae is displayed when it is then opened in 2003.
I need to save as a .xlsb to reduce the file size (6.5mb as .xls v 700ish k in .xlsb).
Thanks
When the file is opened in 2003 I get a warning message about named ranges and/or ranges going beyond 2003's capabilities but upon checking the ranges there is nothing in the Name Manager list of named ranges that go beyond column IV or row 65536.
Currently the file is saved as a .xls via 2007 and when opened in 2003 I don't get any issues, but if saved as a .xlsb file via 2007, the error messgae is displayed when it is then opened in 2003.
I need to save as a .xlsb to reduce the file size (6.5mb as .xls v 700ish k in .xlsb).
Thanks