View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Is there anyway to do this?

No - Excel is limited to 256 columns and that is it!

There are various strategies for wrapping data into multiple rows or using
more than one worksheet but they get horrendously difficult to maintain.

If you post the specifics here there might be a workaround, which will of
course depend on the actual application. But in general if you need more
data columns consider other database products.


--
Cheers
Nigel



"braden" wrote in
message ...

Hello,

I work with an security analyst, who has a spreadsheet stretching out
to column IV. I told him there are limits to the # of columns and
rows, but he seems to think there is/should be a work around.

I am not aware of anything that will override this limit, does anyone
have a suggestion?

Thank you.


--
braden
------------------------------------------------------------------------
braden's Profile:

http://www.excelforum.com/member.php...o&userid=25226
View this thread: http://www.excelforum.com/showthread...hreadid=498007