Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Richard
 
Posts: n/a
Default Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???


H E L P

I'am at a lost - Here is the situation. For a year now, I've been
developping an Excel 2000 workbook. All has been well until a month ago, when
I hit the nasty "Too many different cell Formats" error. This was accompanied
by serveral Excel 2000 crashes as I tried to reduce the number of Formats
used in the Sheet.

I was finally able to reduce the number of formats, and I've continued
development of the workbook - BUT seems that now, Excel 2003 fails to open
the Workbook - a problem which is not present in Excel 2000. Here is all I
know of about this :

- Excel 2000 has NO problem with the Workbook.
- Excel 2003 can load the workbook ONCE, but if you Save & Reload in Excel
2003 - BOOM.
- The workbook does NOT use ANY macros
- The workbook does NOT use User Defined Functions
- The Workbook does NOT use any Add-Ins
- The workbook uses only simple functions, from vlookup to trunc. Nothing
fancy.
- The workbook has alot of Formatting - which is lost when 'repairing' the
workbook.
- When double-clicking on the Workbook to open it (using Excel 2003), the
bottom says "Opening .. (filename)" then there is no progression and
"Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience" (Instead of being sorry, it would be MUCH MORE
useful if they could tell me WHY the <CENSURED it failed.
- I have tried "ExcelFIX Pro Demo v4.20" to see what happends. No errors are
detected.
- I have tried "Advanced Excel Repair" and It does'nt help
- IF i delete one worksheet in Excel 2000, save - then I can reload in Excel
2003. BUT if i save from Excel 2003, the next time I reload - BOOM
- If I try saving (from Excel 2000) in Excel 97 format, then Excel 2000
reports: "A Formula in Cell (Name:tSel_WeaponFocus) could not be converted
because it contains a function that is not available in the file format to
which you are saving. If you continue the save, the Formula and result will
be saved, but the function itself will be converted to an error value." -
First of all, "tSel_WeaponFocus" is a 3 cell table which uses a list for the
input (as Data Validation) - and worst (or best ?!) of all, is that when I
reload back in Excel 2000 the resulting Excel 97 file, that section works
correctly as if there never was any reported error. Doh.
Note that "tSel_WeaponFocus" is the LAST named cell I got... (does this
means something ?)
- In both Excel 2000 and 2003, I tried selecting all worksheets and copying
them to a new workbook - no luck there.
- Here is another weird thing: Sometimes, when starting excel in Safe Mode,
the workbook will load correctly - I've also noticed that using FILE-LOAD
instead of double clicking will allow the workbook to load normally - but I
can't figure out any pattern.

Now, I'am already aware I could start from a previous (working) olded
version, but that would set me back at least ONE MONTH of work. Is there
ANYTHING I can do that would allow Excel 2003 to be able to STOP crashing
while opening a workbook created in Excel 2000 ?!

You're welcome to check my Workbook he (note that you might need to SAVE
from excel 2003 to see it fail the next time you load it):
http://step.polymtl.ca/~ritz/charshe...et_-_v6.43.zip

Thanks
Richard

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???

Hi Richard,

I'm sorry to hear that you're having trouble with your Excel workbook. It sounds like a frustrating situation, but I'll do my best to help you out.

Based on the information you've provided, it seems like the issue may be related to compatibility between Excel 2000 and Excel 2003. While the two versions are similar, there may be some differences in how they handle certain features or functions.

Here are a few things you could try to resolve the issue:
  1. Save the workbook in a different file format: As you mentioned, saving the workbook in Excel 97 format resulted in an error message. However, you could try saving it in a different format, such as Excel 2003 XML or CSV. This may help to eliminate any compatibility issues between the two versions of Excel.
  2. Remove unnecessary formatting: You mentioned that the workbook has a lot of formatting, which may be contributing to the issue. Try removing any unnecessary formatting, such as cell borders or background colors, and see if that helps.
  3. Use the "Detect and Repair" featu Excel has a built-in "Detect and Repair" feature that can help to fix any issues with the program. To access this feature, go to the "Help" menu and select "Detect and Repair". Follow the prompts to complete the repair process.
  4. Check for updates: Make sure that both Excel 2000 and Excel 2003 are fully updated with the latest patches and service packs. This may help to resolve any compatibility issues.
  5. Try using a different computer: If possible, try opening the workbook on a different computer with Excel 2003 installed. This will help to determine if the issue is specific to your computer or if it's a more general compatibility issue.

I hope these suggestions help you to resolve the issue. Let me know if you have any other questions or if there's anything else I can do to assist you.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
without looking at your workbook this sounds for me like a corrupted Excel
file. So my suggestion would be:
- in Excel 2000 create a new workbook
- copy all sheets from your existing workbook to this new workbook
- copy all modules from the old one to this new one
- save this new workbook

Try again with this new version

--
Regards
Frank Kabel
Frankfurt, Germany

Richard wrote:
H E L P

I'am at a lost - Here is the situation. For a year now, I've been
developping an Excel 2000 workbook. All has been well until a month
ago, when I hit the nasty "Too many different cell Formats" error.
This was accompanied by serveral Excel 2000 crashes as I tried to
reduce the number of Formats used in the Sheet.

I was finally able to reduce the number of formats, and I've continued
development of the workbook - BUT seems that now, Excel 2003 fails to
open the Workbook - a problem which is not present in Excel 2000.
Here is all I know of about this :

- Excel 2000 has NO problem with the Workbook.
- Excel 2003 can load the workbook ONCE, but if you Save & Reload in
Excel 2003 - BOOM.
- The workbook does NOT use ANY macros
- The workbook does NOT use User Defined Functions
- The Workbook does NOT use any Add-Ins
- The workbook uses only simple functions, from vlookup to trunc.
Nothing fancy.
- The workbook has alot of Formatting - which is lost when
'repairing' the workbook.
- When double-clicking on the Workbook to open it (using Excel 2003),
the bottom says "Opening .. (filename)" then there is no progression
and "Microsoft Office Excel has encountered a problem and needs to
close. We are sorry for the inconvenience" (Instead of being sorry,
it would be MUCH MORE useful if they could tell me WHY the <CENSURED
it failed. - I have tried "ExcelFIX Pro Demo v4.20" to see what
happends. No errors are detected.
- I have tried "Advanced Excel Repair" and It does'nt help
- IF i delete one worksheet in Excel 2000, save - then I can reload
in Excel 2003. BUT if i save from Excel 2003, the next time I reload
- BOOM - If I try saving (from Excel 2000) in Excel 97 format, then
Excel 2000 reports: "A Formula in Cell (Name:tSel_WeaponFocus) could
not be converted because it contains a function that is not available
in the file format to which you are saving. If you continue the save,
the Formula and result will be saved, but the function itself will be
converted to an error value." - First of all, "tSel_WeaponFocus" is a
3 cell table which uses a list for the input (as Data Validation) -
and worst (or best ?!) of all, is that when I reload back in Excel
2000 the resulting Excel 97 file, that section works correctly as if
there never was any reported error. Doh.
Note that "tSel_WeaponFocus" is the LAST named cell I got... (does
this means something ?)
- In both Excel 2000 and 2003, I tried selecting all worksheets and
copying them to a new workbook - no luck there.
- Here is another weird thing: Sometimes, when starting excel in Safe
Mode, the workbook will load correctly - I've also noticed that using
FILE-LOAD instead of double clicking will allow the workbook to load
normally - but I can't figure out any pattern.

Now, I'am already aware I could start from a previous (working) olded
version, but that would set me back at least ONE MONTH of work. Is
there ANYTHING I can do that would allow Excel 2003 to be able to
STOP crashing while opening a workbook created in Excel 2000 ?!

You're welcome to check my Workbook he (note that you might need
to SAVE from excel 2003 to see it fail the next time you load it):
http://step.polymtl.ca/~ritz/charshe...et_-_v6.43.zip

Thanks
Richard



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
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 03:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 11:20 PM
pivotcell object to excel 2000 Kellyc Excel Discussion (Misc queries) 0 December 1st 04 04:45 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 01:07 AM


All times are GMT +1. The time now is 09:24 AM.

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

About Us

"It's about Microsoft Excel"