Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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








  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,339
Default 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









  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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













  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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














  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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














Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
memory problem of Excel 2003 copy & paste LunaMoon Excel Discussion (Misc queries) 5 August 13th 08 01:51 PM
memory problem in Excel 2007 Tessa - South Africa Excel Discussion (Misc queries) 1 August 5th 08 01:31 PM
Memory problem or Excel limitation Jac Tremblay[_4_] Excel Programming 5 March 23rd 05 05:55 PM
memory problem with excel valery8 Excel Programming 2 July 29th 04 03:15 PM
Excel memory problem Valeria[_2_] Excel Programming 1 December 5th 03 06:39 PM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"