C
cc
What's the maximum size an Excel Worksheet can be before it becomes an issue?
J
JoAnn Paules
An issue for whom? Each system will be different.
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
C
cc
User has an 11mb worksheet that takes awhile to calculate, just wondering if
there's a max. size limit per worksheet, before system start locking up.
there's a max. size limit per worksheet, before system start locking up.
JoAnn Paules said:
B
Bob I
Sounds like for that particular computer CPU and memory and background
program configuration, recalcing 11mb is a bit much. Different computer
will act differently.
program configuration, recalcing 11mb is a bit much. Different computer
will act differently.
C
cc
Thanks Bob
Bob I said:
C
cc
Thanks JoAnn
JoAnn Paules said:
B
Bob Buckland ?:-\)
Hi C.C.,
You may want to also post this question in the MS Office Excel discussion group through the links below and include there the
version(s) of Excel you have available. Excel 2007, for example, supports a much larger spreadsheet model that prior Excel verions
especially when tied to the new Excel Services capabilities of Office 2007 Sharepoint services for server side spreadsheet
calculations can make a difference in performance.
Generally, the physical size of the spreadsheet, while a factor, is less of an influence than the number, complexitiy and
interdependence of the calculations within a sheet, but the folks in the Excel group may be able to provide some tips on improving
performance for a specific scenario and version.
===============
User has an 11mb worksheet that takes awhile to calculate, just wondering if
there's a max. size limit per worksheet, before system start locking up. >>
--
Please let us know if this has helped,
Bob Buckland ?
MS Office System Products MVP
LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
You may want to also post this question in the MS Office Excel discussion group through the links below and include there the
version(s) of Excel you have available. Excel 2007, for example, supports a much larger spreadsheet model that prior Excel verions
especially when tied to the new Excel Services capabilities of Office 2007 Sharepoint services for server side spreadsheet
calculations can make a difference in performance.
Generally, the physical size of the spreadsheet, while a factor, is less of an influence than the number, complexitiy and
interdependence of the calculations within a sheet, but the folks in the Excel group may be able to provide some tips on improving
performance for a specific scenario and version.
===============
User has an 11mb worksheet that takes awhile to calculate, just wondering if
there's a max. size limit per worksheet, before system start locking up. >>
--
Please let us know if this has helped,
Bob Buckland ?
MS Office System Products MVP
LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com