Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MC
 
Posts: n/a
Default Really Strange Excel Issue

I have a Windows 2003 domain with all win 2003 servers. My workstations are
windows 2000 with office xp installed. I have in the last week or so 3
different calls from users with the same problem. They created a spreadsheet
in excel with formulas and saved the file. When the went to open the file
again later on, the file was a word document, with a .doc extension. Word
opened the file fine of course without the formulas but if I try to open the
file in excel, excel tells me the file format is invalid. I then tried to
rename the extension to .xls, same error. Also tried opening the file in
word and saving as "filename.xls" and that didn't work.
Anyone have any clue as to what is going on? And more importantly is there
anyway of recovering the excel sheet?
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

MC,

Perhaps a user is opening them with Word and saving them. That doesn't
explain what happened to the original *.xls files, though.

There's a problem with Word where an xls file can be opened in Word, and
then saved. The user gets a "This document will be saved in Word format" as
you would expect. Unfortunately, it overwrites the xls file; it doesn't
change the extension to .doc. It can no longer be opened with Excel.
Formulas and other spreadsheet functionality are lost. This problem existed
at least through Word 2002, and at least as far back as Word 97. There has
been lost data and tears over that one, and it went on for a while. It
might still be going on with Word 2003, I don't know.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"MC" wrote in message
...
I have a Windows 2003 domain with all win 2003 servers. My workstations
are
windows 2000 with office xp installed. I have in the last week or so 3
different calls from users with the same problem. They created a
spreadsheet
in excel with formulas and saved the file. When the went to open the file
again later on, the file was a word document, with a .doc extension. Word
opened the file fine of course without the formulas but if I try to open
the
file in excel, excel tells me the file format is invalid. I then tried to
rename the extension to .xls, same error. Also tried opening the file in
word and saving as "filename.xls" and that didn't work.
Anyone have any clue as to what is going on? And more importantly is there
anyway of recovering the excel sheet?



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
opening multiple instances of excel John B Excel Discussion (Misc queries) 4 January 28th 05 11:31 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Compatibility between Excel XP and Previous Excel versions? mike333 Excel Discussion (Misc queries) 1 January 14th 05 02:19 AM


All times are GMT +1. The time now is 09:21 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"