#1   Report Post  
instauratio
 
Posts: n/a
Default html

I have a user who emailed a spreadsheet from home to the office. When he
arrived this morning he found it is in html. He has been working for several
hours making changes and I want to some how convert this back to an xls file.

Is it possible to convert this html to xls? and will I be able to save all
of the work he did while it was in html?
Thanks
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

Just open it in Excel. Excel can read what it saved. You should get back
all or most of what you had. Bizarre though to have saved in HTML by
accident; it's not exactly an easy mistake to make.

--
Jim
"instauratio" wrote in message
...
|I have a user who emailed a spreadsheet from home to the office. When he
| arrived this morning he found it is in html. He has been working for
several
| hours making changes and I want to some how convert this back to an xls
file.
|
| Is it possible to convert this html to xls? and will I be able to save all
| of the work he did while it was in html?
| Thanks


  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

make a copy of the file and try opening the copy in Excel to see what
happens. There are so many things that can be different, and it is not
working with Excel when it is in HTML. While it was being worked on
in HTML was it an office program that was being used.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"instauratio" wrote in message ...
I have a user who emailed a spreadsheet from home to the office. When he
arrived this morning he found it is in html. He has been working for several
hours making changes and I want to some how convert this back to an xls file.

Is it possible to convert this html to xls? and will I be able to save all
of the work he did while it was in html?
Thanks



  #4   Report Post  
instauratio
 
Posts: n/a
Default

I found that by "editing with excel" and then "saving as a worksheet" I was
able to satisfy the user.

I think that the user hit "save as a web page" by accident which is listed
right below the traditional "save as".

thanks for the help!

"David McRitchie" wrote:

make a copy of the file and try opening the copy in Excel to see what
happens. There are so many things that can be different, and it is not
working with Excel when it is in HTML. While it was being worked on
in HTML was it an office program that was being used.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"instauratio" wrote in message ...
I have a user who emailed a spreadsheet from home to the office. When he
arrived this morning he found it is in html. He has been working for several
hours making changes and I want to some how convert this back to an xls file.

Is it possible to convert this html to xls? and will I be able to save all
of the work he did while it was in html?
Thanks




  #5   Report Post  
David McRitchie
 
Posts: n/a
Default

Thanks for the update, it hadn't even occurred to me until I saw the
other answer that this person had saved it as HTML while continuing
to work with the file in Excel.


"instauratio" wrote...
I found that by "editing with excel" and then "saving as a worksheet" I was
able to satisfy the user.

I think that the user hit "save as a web page" by accident which is listed
right below the traditional "save as".



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
extract text from html files Glowinafuse Excel Discussion (Misc queries) 3 May 31st 05 06:23 AM
Convert HTML into an Excel skydiving99 Excel Worksheet Functions 1 March 18th 05 11:35 PM
html to excel nellie Excel Discussion (Misc queries) 4 February 8th 05 10:37 PM
save as html writenick Excel Discussion (Misc queries) 0 January 13th 05 05:25 PM
html filter DavidR Excel Discussion (Misc queries) 0 December 13th 04 07:19 PM


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