Available Excel Resource's Testing

[Matt]

Does anyone know how to test for current stack space "being used" vs. total
stack space "available" in Excel, as well as "total memory available" vs.
"the current memory being used" (all in terms of Excel's allotments given
and Excel's restrictions put in place as maximum's in these regards)?



I have Excel 2003 Pro, it limits you to 1 gig of RAM for example, regardless
of what you have on your server. My server has 2 gig's, hosting 30 users via
Citrix Metaframe. I'm about to add 40 more users, I'm wondering if I will
crash due to any of the above criteria being exceeded (or any other relevant
criteria I am not aware of). I'm also wondering if each user running their
own insteance of the workbooks in Excel as "read only" EACH get 1 gig of
memory, or if ALL USERS PERIOD are limited to "1 gig total" aggregately
while all on my server?



Thank You,

Matt

 

[Charles Williams]

Each instance of Excel tries to have its own memory space within the overall
operating system/environment limits.
The Excel 2003 memory limit per instance is 1 gigabyte heap space (excludes
data)

see http://www.decisionModels.com/memlimitsc.htm for more details on memory
limits

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

 

[Matt]

Thank You.
Matt

Each instance of Excel tries to have its own memory space within the
overall operating system/environment limits.
The Excel 2003 memory limit per instance is 1 gigabyte heap space
(excludes data)

see http://www.decisionModels.com/memlimitsc.htm for more details on
memory limits

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com