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

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" wrote in message
...
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

Thank You.
Matt

"Charles Williams" wrote in message
...
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" wrote in message
...
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