Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 04, 10:35 AM
Wil
 
Posts: n/a
Default Saving a Excel 97 file into Excel 2003 file

There is no problem in opening a Excel97 file into Excel 2003. The problem
occurs when trying to perform "Save As" after that. The error message is
"Excel cannot complete this task with available resources. Choose less data
or close other applications."

The file is only about 2.5MB and there is no other applications running in
the background except the normal firewall and antivirus programs.

The interesting thing about this problem is that, it occurs on one PC and
not on another? Both PC got 512MB DDR Ram and plenty of space in hard
drives. The total paging size is 768MB for both PCs. I have increased the
paging size to 1000MB but that does not help the problem. The PC showing
this problem got a P4 CPU and AGP display card supporting dual monitors,
whereas the other working PC got a Celeron CPU and a basic PCI display card
supporting single monitor.

I have tried to open the Excel 2003 file that was successfully saved in the
Celeron PC and it causes no problem in opening or saving.

Any suggestions?



  #2   Report Post  
Old December 14th 04, 12:51 AM
Dave Peterson
 
Posts: n/a
Default

I don't know why you're having trouble on one pc, but not the other.

But maybe you could close excel and try cleaning up the windows temp folder.
(just a guess).

If that fails, can you copy the worksheets to a different workbook and save
there?

If that fails, can you copy the cells on each worksheet and paste them to a new
worksheet in a new workbook and save there?



Wil wrote:

There is no problem in opening a Excel97 file into Excel 2003. The problem
occurs when trying to perform "Save As" after that. The error message is
"Excel cannot complete this task with available resources. Choose less data
or close other applications."

The file is only about 2.5MB and there is no other applications running in
the background except the normal firewall and antivirus programs.

The interesting thing about this problem is that, it occurs on one PC and
not on another? Both PC got 512MB DDR Ram and plenty of space in hard
drives. The total paging size is 768MB for both PCs. I have increased the
paging size to 1000MB but that does not help the problem. The PC showing
this problem got a P4 CPU and AGP display card supporting dual monitors,
whereas the other working PC got a Celeron CPU and a basic PCI display card
supporting single monitor.

I have tried to open the Excel 2003 file that was successfully saved in the
Celeron PC and it causes no problem in opening or saving.

Any suggestions?


--

Dave Peterson


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
Disable Query Refresh warning dialog box in Excel 2003 Jeff Koons Excel Discussion (Misc queries) 2 December 1st 05 05:08 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 03:17 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 09:21 AM
Excel 2003 "File Open": how keep folders at top with sort by Date. Aging Analyst Excel Discussion (Misc queries) 1 December 3rd 04 04:26 AM


All times are GMT +1. The time now is 03:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017