ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Out of memory? (https://www.excelbanter.com/excel-discussion-misc-queries/57632-out-memory.html)

JENNYC

Out of memory?
 

Hi there! I have a very large workbook i am almost done creating and
just ran into a little hiccup: It locked up on me, telling me i have
no memory available (memory in Excel). Now i cannot even open it
anymore. I am using the 2000 version of Excel and a coworker i am
designing this for is using 2003. when i go to his computer annd oopen
it, it works...but not from mine. Now here's my question: Does the
2003 version have more memory available than 2000's? I am not finished
with the workbook, but i am close....hoowever i am not going to go
through the trouble to complete it if i am going to run out of memory
again!! If i install 2003, will that give me more memory, & if so, how
much? My workbook is currently using 55.4 mb...anybody know how much
more i can squeeze in there?? Any advice is greatly appreciated!!
thanks! Jenny


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=488888


Bill Martin

Out of memory?
 
JENNYC wrote:
Hi there! I have a very large workbook i am almost done creating and
just ran into a little hiccup: It locked up on me, telling me i have
no memory available (memory in Excel). Now i cannot even open it
anymore. I am using the 2000 version of Excel and a coworker i am
designing this for is using 2003. when i go to his computer annd oopen
it, it works...but not from mine. Now here's my question: Does the
2003 version have more memory available than 2000's? I am not finished
with the workbook, but i am close....hoowever i am not going to go
through the trouble to complete it if i am going to run out of memory
again!! If i install 2003, will that give me more memory, & if so, how
much? My workbook is currently using 55.4 mb...anybody know how much
more i can squeeze in there?? Any advice is greatly appreciated!!
thanks! Jenny


-------------------------

Are you really sure it's 54MB? Have you done the exercise of deleting all the
unused cells that Excel has mistakenly decided are used, and stores? Doing so
cut some of my files by 50%.

You can go to this web site to read up on it:

http://www.contextures.com/xlfaqApp.html

Search the page of for the phrase "Why do my scrollbars go to row 500"" which
occurs about half way down the page.

Good luck...

Bill


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com