N Nick Hodge Dec 8, 2003 #2 Not really, although they behave better when you avoid doing certain things. I have a weekly updated pivot table which I think currently resides at around 60mb. Works fine...(fingers and toes crossed) You might get some ideas from this site http://www.decisionmodels.com/memlimits.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
Not really, although they behave better when you avoid doing certain things. I have a weekly updated pivot table which I think currently resides at around 60mb. Works fine...(fingers and toes crossed) You might get some ideas from this site http://www.decisionmodels.com/memlimits.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed)
P Pegl Dec 16, 2003 #3 There is a limit to the number of rows and columns a sheet can have, however. The limits are 65536 rows and 256 columns.
There is a limit to the number of rows and columns a sheet can have, however. The limits are 65536 rows and 256 columns.
