Re: Excel File corrupted by word file
- From: "Earl Kiosterud" <someone@xxxxxxxxxxx>
- Date: Mon, 30 Oct 2006 21:30:06 -0500
Bruce,
True. You can paste Word stuff into Excel. But formulas are gone -- you
get only the values the formulas yielded at the time of the crime.
Conditional formatting - gone. Macros - gone. Scenarios, sheet names, most
formatting (locked, number formatting, etc. etc.) and way more, all gone.
It's just a bunch of static tables, one per original sheet, now.
It's true that Word warns that the file will be saved in Word format, but
its keeping the xls extension causes it to overwrite the original workbook
file. That's the outrage. That should have been fixed releases ago. With
all the billions floating around at Microsoft, there must be a programmer
somewhere they could hire to take care of something as simple and serious as
this. The Excel group should be raising total hell with the Word group if
they have any guts at all.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Bruce Sinclair" <bruce.sinclair@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:ei62j6$slq$1@xxxxxxxxxxxxxxx
In article <#dPXGsU#GHA.3344@xxxxxxxxxxxxxxxxxxxx>, "Earl Kiosterud"
<someone@xxxxxxxxxxx> wrote:
RJM,
The most likely thing is that someone opened the xls file in Word, then
saved. Now it's a Word file. No formulas. Spreadsheet functionality
lost
for good. It's outrageous on the part of Microsoft that this hasn't been
changed, but Word, though it warns the user, overlays the original xls
file
with a word file. It ain't a spreadsheet any more. Still has the xls
extension. No one hears your screams.
:)
Might be possible to recover the data by copying from word and pasting it
into xl again. Has been known to work ... and yet ... see above :)
Best of luck.
.
- References:
- Re: Excel File corrupted by word file
- From: Earl Kiosterud
- Re: Excel File corrupted by word file
- From: Bruce Sinclair
- Re: Excel File corrupted by word file
- Prev by Date: Re: turning off formula bar
- Next by Date: Re: 2003 Macro Issue
- Previous by thread: Re: Excel File corrupted by word file
- Next by thread: Numbered steps
- Index(es):
Relevant Pages
|
