ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using large excel files (https://www.excelbanter.com/excel-worksheet-functions/9847-using-large-excel-files.html)

Tom Trahan

Using large excel files
 
I have several large excel files that are linked to other files. Some are in
excess of 10MB. I am gettting a message that is causing an error message:

Appname: excel.exe AppVer: 8.0.1.5618
Modname: excel.exe Modver: 8.0.1.5618
Offset: 00249092

To view technical info. .... click here.

Is this a resource problem since the files are large.

I have no clue

Any help is appreciated.

Tom Trahan


not sure. not technical data.
maybe.
in excel help, type specifications.
this will tell the specs of your version excel. version
vary
do ctrl+alt+del to bring up task manager
the performance tab will tell you how much memory is in use
the processes tab will break mem use down by application
in windows, call up the dos command window. typem mem
this will tell you how much mem your machine has.
in excel, on any sheet, in any three cells
=info("totmem")
=info("memused")
=info("memavail")
this will tell you how much mem excel is eating up.
good luck

-----Original Message-----
I have several large excel files that are linked to other

files. Some are in
excess of 10MB. I am gettting a message that is causing

an error message:

Appname: excel.exe AppVer: 8.0.1.5618
Modname: excel.exe Modver: 8.0.1.5618
Offset: 00249092

To view technical info. .... click here.

Is this a resource problem since the files are large.

I have no clue

Any help is appreciated.

Tom Trahan
.



All times are GMT +1. The time now is 12:29 PM.

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