Adding columns past the 256 limit

  • Thread starter Thread starter melvin
  • Start date Start date
M

melvin

Hi folks,

Is there any way of extending the number of columns past the 256 limi
(MS Excel 97 version)??

many thanks for any input

Best regards
 
No. Nor in 2000, XP or 2003.

If you really need more than 256 columns take a look at Quattro Pro.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Hi
this is the maximum (also for Excel 2003). If you need more columns you
may:
- split your data on separate worksheets
- use a different spreadsheet application (e.g. Quatro Pro)
- move to a database application
 
Hi

There is one option more:
-redesign the workbook so, that there aren't so many worksheets needed at
all
(p.e. all entries are made into single table, and to get any needed
printouts/views , special report sheets with dropdowns to determine the
selection are used)
 
Back
Top