View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Compatibility Issue

In a word: No. Even with the compatibility pack installed in the older
version of Excel, it's simply not going to be able to deal with columns
beyond the 256th column (IV).

I don't know what you're building, but I really must ask if you haven't
considered some other solution, such as a database application.

"WLMPilot" wrote:

I am using 2007 version of Excel to design a spreadsheet at work. It is
capable of over handling over 16,000 columns.

The users of my spreadsheat have 2002 version of Excel. If the
update/upgrade via downloading the compatibility software, will they then be
able to also handle the 16,000+ columns?

My design is utilizing 3000 columns per worksheet with over 100 worksheets
in the workbook.

Thanks,
Les