Hi,
I would really appreciate it if someone could confirm whether this is standard behaviour or not. If i open an excel 97 file in word 97 but close word without saving the file, the file is now in word format and excel will refuse to open it (Filename:file format is not valid).
A simple example -
Open Excel 97 and create a new workbook. Just type some text in one cell. Save as TEST.XLS
Now open the file in Word 97 using File-Open from within Word itself. A "Open Worksheet" dialog pops up, I choose the default of Entire Workbook. The text now shows up in a one cell table.
Now close Word - note I do not get a Save? message.
Now open the file in Excel - you can't! The file has been changed to Word format just by opening it in Word.
Any help on this would be greatly appreciated as it driving one particular user nuts
Cheers
Colm
I would really appreciate it if someone could confirm whether this is standard behaviour or not. If i open an excel 97 file in word 97 but close word without saving the file, the file is now in word format and excel will refuse to open it (Filename:file format is not valid).
A simple example -
Open Excel 97 and create a new workbook. Just type some text in one cell. Save as TEST.XLS
Now open the file in Word 97 using File-Open from within Word itself. A "Open Worksheet" dialog pops up, I choose the default of Entire Workbook. The text now shows up in a one cell table.
Now close Word - note I do not get a Save? message.
Now open the file in Excel - you can't! The file has been changed to Word format just by opening it in Word.
Any help on this would be greatly appreciated as it driving one particular user nuts
Cheers
Colm