Spinning Pinwheel when using "indirect" functions.
Has anyone else noted that numbers is very slow when you use indirect function?
I am doing something like this: =indirect(concatenate("Data::",B$1,$A2)) where I put the row number and column letter in these two references. This allows me to map the data from this other table "Data" into this table. When I have even as few as 24 rows and 10 columns it takes 5 minutes to compute this. During this time I get the spinning colored pinwheel and Numbers freezes up. It eventually comes back, but doing any edits in this spreadsheet have become very diffcult because the pinwheel likes to come back. Even opening the spreadsheet will cause a 5 minute wait when I view this table. When I really get serious with my data analysis, I copy this to 240 rows and 10 columns and now I am hung for over 30 minutes.
I am running Numbers '09 v2.1 in Lion 10.7.2 on MacBook Pro 2.53MHz, Quad processors, Core i5 with 4GB of memory. I don't have any other applications runnning other than Safari and Mail.
This is very frustrating. I just wonder if other people are having this problem and if there is a work-around other than waiting for an update.
MacBook Pro (17-inch Mid 2010), Mac OS X (10.7.2)