Array Problems

[Bennett_Yankowitz]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Email Client: imap

I have had an issue with spreadsheets using the "transpose function." If I use it too many times in a single spreadsheet (15 seems to be the max), Excel 2008 refuses to save the document. That is, when I try to "save as" using a new file name the program crashes. I have had this issue on several different Macs. Is there a maximum number of arrays or transpose functions that Excel can handle? The arrays I am using are typically 1 row by 10 columns.

 

[Michel Bintener]

Hi Bennett,

you've (accidentally) posted in the Entourage newsgroup. While there are
some proficient Excel users in here, your chances of getting a satisfying
answer are definitely higher in the Excel newsgroup.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Email Client: imap

I have had an issue with spreadsheets using the "transpose function." If I use
it too many times in a single spreadsheet (15 seems to be the max), Excel 2008
refuses to save the document. That is, when I try to "save as" using a new
file name the program crashes. I have had this issue on several different
Macs. Is there a maximum number of arrays or transpose functions that Excel
can handle? The arrays I am using are typically 1 row by 10 columns.

--
Michel Bintener
Microsoft MVP
Office:mac (Entourage & Word)

*** Please always reply to the newsgroup. ***