ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Out of Resources" Message (https://www.excelbanter.com/excel-programming/354365-out-resources-message.html)

groundhog1

"Out of Resources" Message
 
Hi,

I have an excel spreadsheet that is getting bigger as I develop it.

It talks over the lan to a piece of electronic gear, gets measurments, and
grabs a screen shot (.bmp) of the equipment LCD screen.

In one worksheet, I am going for my third set of data and screenshot when
the out of resources message appears.

I used to be able to close then open Excel to fix the problem. Now that
doesn't work (bigger workbook).

In Windows Task manager, it doesn't appear that I am running out of
memory.

Isn't Excel only limited by your hardware?

Anyway, if you have any ideas, thankyou.

groundhog


Jim Thomlinson[_5_]

"Out of Resources" Message
 
Give this a look...

http://www.decisionmodels.com/memlimits.htm
--
HTH...

Jim Thomlinson


"groundhog1" wrote:

Hi,

I have an excel spreadsheet that is getting bigger as I develop it.

It talks over the lan to a piece of electronic gear, gets measurments, and
grabs a screen shot (.bmp) of the equipment LCD screen.

In one worksheet, I am going for my third set of data and screenshot when
the out of resources message appears.

I used to be able to close then open Excel to fix the problem. Now that
doesn't work (bigger workbook).

In Windows Task manager, it doesn't appear that I am running out of
memory.

Isn't Excel only limited by your hardware?

Anyway, if you have any ideas, thankyou.

groundhog




All times are GMT +1. The time now is 09:06 PM.

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