.xlsb file opened in Excel 2003

[mikeymay]

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

 

[mikeymay]

The template does not have any further ranges added to it during the compilation process.

 

[Firefly2012]

A dynamically defined range is one that is based on a formula such as:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

These would be visible within Name Manager (in xl2007+). Do you have any of these (may be based on other formulas, not just OFFSET)?

 

[mikeymay]

All the ranges are 'hard coded' and are not established by formulas.

To be honest, I didn't even know that a range could be established by entering a formula into the Name manager!

 

[Andrew Poulsom]

Do you want to Email the workbook to me?

 

[mikeymay]

Sorry Andrew, but I can't email attachements out to external email addresses. Is a bummer, but nothing I can do to get around that.