Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Weird File Open/Save As Behavior

A client of ours has one particular file that has some very strange
behavior as described below. This only occurs with the one particular
file and the behavior is consistent across different PC's in both their
office and ours. All other Excel files in both offices work fine.

Here's what happens:

- you can use Windows Explorer to copy the file between drives without
a problem (as expected)

- if you open the file in Excel on one drive then save it back to that
same drive with either the same file name or a different file name, the
file works fine (as expected)

- if you open the file in Excel on one drive then do a "Save As" to
save it to a *different* drive with either the same file name or a
different file name (in default .xls format), the new file causes
errors in Excel every time you open it as per below (weird!)

- even if you do a "Save As" and choose a different format eg Excel
97-2003 or Excel 95, the error behavior is consistent (weird!)

What happens when opening the Save As version is:
- you open the file (using either Excel or Windows Explorer)
- the Enable Macros dialog box appears twice (with non "save as"
versions, this only appears once as normal)
- an error message appears stating that:
"Errors were detected in the file but Microsoft Office Excel was able
to open the file by making the repairs listed below. Save the file to
make these repairs permanent."

In the error log txt file, we get:


"Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\Jeff Robson\My
Documents\test.xls'
The following is a list of repairs:

Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted."


When Excel "repairs" the file, it strips out all the formatting and
formulas, leaving you with just a series of sheets with hard-coded
numbers (not a particularly useful repair job!).

We're running Excel 2003 on WinXP (SP2) however the behavior is
consistent on Excel 2002 as well (haven't tested other versions).

Any ideas? Anyone seen this kind of behavior before?

Weird!

Jeff Robson
www.mailbarrow.com

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
Double-clicking .xls file opens Excel but doesn't open the file DG Excel Discussion (Misc queries) 4 January 6th 06 03:20 AM
Excel file automatically opens Lost4Now Excel Discussion (Misc queries) 6 December 4th 05 10:35 PM
Links picking up values from an older version of linked file Cate Links and Linking in Excel 4 October 20th 05 01:53 PM
cannot open excel file, please help!!! sunlite Excel Discussion (Misc queries) 0 September 5th 05 05:29 PM
weird file name in excel anders h Excel Discussion (Misc queries) 3 February 24th 05 06:25 PM


All times are GMT +1. The time now is 01:58 PM.

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"