ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Another Excel 97 Problem: Not enough memory (https://www.excelbanter.com/excel-programming/351842-another-excel-97-problem-not-enough-memory.html)

Karoo News[_2_]

Another Excel 97 Problem: Not enough memory
 
I have a workbook created on Excel XP2002 which will not open in 97. The
workbook is approx 4.2mb but that is not the problem as I have larger
workbooks that open fine. When I try and launch it I just get not enough
memory!

Any Ideas?

Regards
Neil




Kou Vang[_2_]

Another Excel 97 Problem: Not enough memory
 
You cannot open newer files of Excel with Older versions.

"Karoo News" wrote:

I have a workbook created on Excel XP2002 which will not open in 97. The
workbook is approx 4.2mb but that is not the problem as I have larger
workbooks that open fine. When I try and launch it I just get not enough
memory!

Any Ideas?

Regards
Neil





Karoo News[_2_]

Another Excel 97 Problem: Not enough memory
 
All other files I have created on new excel do tho'

Neil

"Kou Vang" wrote in message
...
You cannot open newer files of Excel with Older versions.

"Karoo News" wrote:

I have a workbook created on Excel XP2002 which will not open in 97. The
workbook is approx 4.2mb but that is not the problem as I have larger
workbooks that open fine. When I try and launch it I just get not enough
memory!

Any Ideas?

Regards
Neil









Toppers

Another Excel 97 Problem: Not enough memory
 
. ... but were they created with file type "Microsoft Excel 97"?

"Karoo News" wrote:

All other files I have created on new excel do tho'

Neil

"Kou Vang" wrote in message
...
You cannot open newer files of Excel with Older versions.

"Karoo News" wrote:

I have a workbook created on Excel XP2002 which will not open in 97. The
workbook is approx 4.2mb but that is not the problem as I have larger
workbooks that open fine. When I try and launch it I just get not enough
memory!

Any Ideas?

Regards
Neil










Tom Ogilvy

Another Excel 97 Problem: Not enough memory
 
The filetype has not changed from xl97. xl97, xl2000, xl2002, xl2003 all
have the same filetype.

to the OP.

Do you have any worksheets with the zoom level set to other than 100%.
Particularly pages that have alot of objects on the sheets such as activeX
controls, and charts.

Do you have a lot of charts in the workbook?

--
Regards,
Tom Ogilvy



"Toppers" wrote in message
...
. ... but were they created with file type "Microsoft Excel 97"?

"Karoo News" wrote:

All other files I have created on new excel do tho'

Neil

"Kou Vang" wrote in message
...
You cannot open newer files of Excel with Older versions.

"Karoo News" wrote:

I have a workbook created on Excel XP2002 which will not open in 97.

The
workbook is approx 4.2mb but that is not the problem as I have larger
workbooks that open fine. When I try and launch it I just get not

enough
memory!

Any Ideas?

Regards
Neil












Karoo News[_2_]

Another Excel 97 Problem: Not enough memory
 
Nearly all 57 sheets are 85%!

very little active x

neil

"Tom Ogilvy" wrote in message
...
The filetype has not changed from xl97. xl97, xl2000, xl2002, xl2003
all
have the same filetype.

to the OP.

Do you have any worksheets with the zoom level set to other than 100%.
Particularly pages that have alot of objects on the sheets such as activeX
controls, and charts.

Do you have a lot of charts in the workbook?

--
Regards,
Tom Ogilvy



"Toppers" wrote in message
...
. ... but were they created with file type "Microsoft Excel 97"?

"Karoo News" wrote:

All other files I have created on new excel do tho'

Neil

"Kou Vang" wrote in message
...
You cannot open newer files of Excel with Older versions.

"Karoo News" wrote:

I have a workbook created on Excel XP2002 which will not open in 97.

The
workbook is approx 4.2mb but that is not the problem as I have
larger
workbooks that open fine. When I try and launch it I just get not

enough
memory!

Any Ideas?

Regards
Neil















Karoo News[_2_]

Another Excel 97 Problem: Not enough memory
 
It was the graphs & the Zoom, thanks Tom again!

"Tom Ogilvy" wrote in message
...
The filetype has not changed from xl97. xl97, xl2000, xl2002, xl2003
all
have the same filetype.

to the OP.

Do you have any worksheets with the zoom level set to other than 100%.
Particularly pages that have alot of objects on the sheets such as activeX
controls, and charts.

Do you have a lot of charts in the workbook?

--
Regards,
Tom Ogilvy



"Toppers" wrote in message
...
. ... but were they created with file type "Microsoft Excel 97"?

"Karoo News" wrote:

All other files I have created on new excel do tho'

Neil

"Kou Vang" wrote in message
...
You cannot open newer files of Excel with Older versions.

"Karoo News" wrote:

I have a workbook created on Excel XP2002 which will not open in 97.

The
workbook is approx 4.2mb but that is not the problem as I have
larger
workbooks that open fine. When I try and launch it I just get not

enough
memory!

Any Ideas?

Regards
Neil
















All times are GMT +1. The time now is 07:22 PM.

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