Thread
:
1 Question (no work involved)
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Harker
external usenet poster
Posts: 162
1 Question (no work involved)
Hi seeya ste!
See:
Charles Williams:
http://www.decisionmodels.com/memlimitsc.htm
You'll see that the limits vary with Excel version but that Excel 2003
should be able to handle it.
You might also make your file size much smaller by making the used
range more efficient.
You might also make your code more efficient by using Rob Bovey's
CodeCleaner:
Stephen Bullen hosted (temporary location):
http://66.206.3.208/MVP/Default.htm
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"ste mac" wrote in message
om...
Hi There,
I have a spreadsheet which stands right now at 118meg... it runs
fine,
I was going to make a move that would increase the file size to over
135meg or bigger, l am no-programmer and l use this ng for snippets
of code from the high flyers to use in my program...
My question is: when is too big actually too big? does it depend on
the
machine? or will Excel just give in at some stage?
thanks
seeya ste
Reply With Quote
Norman Harker
View Public Profile
Find all posts by Norman Harker