Compatability problem - Data beyond 256 columns...

[Steve at Pod LLP]

I have created a large spreadsheet about 3mb in Excel 2007.

When I save this for use on a 2003 machine, it says that there is data beyond the maximum columns and rows....

If I goto find error, it refers to a cell that is well within the range permitted. I have gone to each sheet and selected goto (F5), special and selected last cell. I can't find anything anywhere near the limit.

What is strange is thta the warning does not appear when I save the file with the sheet in question selected. Instead it only comes up if I am on a different sheet.

I have looked on the net for a solution and some had posts stating that the cell Excel thinks is outside the 2003 range refers to merged cells or has merged dependents, but my spreadsheet does not have this.

It is a major problem because some of our clients use 2003 and when they open it, they get a warning that it is not compataible and data will belost which is not the case.

Can anyone help?

[pike]

Hi Steve

bummer...2003 only has 256 columns, no fix that I have heard of
can you reduce the coulmn in 2007?

[DonkeyOte]

I think Steve is saying he has no data outside of the 65536/256 boundaries, correct ?

[Wizz]

Hi Steve,
You have to be aware that Excel 2003 only has 256 columns and 65536 rows. Check in your excel 2007 for any data beyond this range.

Also problematic (at least in excel 2003) are the comments. Be carefull to check not only where the comment is located, but also over wich cells the comment box is displayed.

Check also for minimizes shapes hidden on the last columns.