ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   if you've accidentally saved a huge spreadsheet as a web doc... (https://www.excelbanter.com/excel-discussion-misc-queries/90174-if-youve-accidentally-saved-huge-spreadsheet-web-doc.html)

gwenwifar

if you've accidentally saved a huge spreadsheet as a web doc...
 
mom is an accountant and works with lots of spread sheets - one of the
project managers, who is not very computer savvy at all, accidentally saved a
huge (and important) spreadsheet as a web document. Windows broke it up into
a whole web, making each page of the spread sheet its own file and the bar
into the navigation. So now there are some 60 files instead of one and of
course, the formulas and things are probably gone. Since i'm pretty good at
computers (though i haven't used excel is ages), i was asked to see if i
could help. I assumed that if excel can create these web files, it should be
able to open them, but when i tried, it kept trying to find the "big" file
and would not open any of the individual web pages. Any ideas? can it be
reconverted? are the formulas even still there?
Thank you very much for any help you can provide,

Dominic LeVasseur

if you've accidentally saved a huge spreadsheet as a web doc...
 
Gwenifar,

Saving as a webpage doesn't delete (overwrite) the original excel document.
Is that still available?



"gwenwifar" wrote:

mom is an accountant and works with lots of spread sheets - one of the
project managers, who is not very computer savvy at all, accidentally saved a
huge (and important) spreadsheet as a web document. Windows broke it up into
a whole web, making each page of the spread sheet its own file and the bar
into the navigation. So now there are some 60 files instead of one and of
course, the formulas and things are probably gone. Since i'm pretty good at
computers (though i haven't used excel is ages), i was asked to see if i
could help. I assumed that if excel can create these web files, it should be
able to open them, but when i tried, it kept trying to find the "big" file
and would not open any of the individual web pages. Any ideas? can it be
reconverted? are the formulas even still there?
Thank you very much for any help you can provide,


Dave Peterson

if you've accidentally saved a huge spreadsheet as a web doc...
 
There should be a file named *.htm in the folder that holds the *_files folder.

You should be able to open that *.htm file directly (let excel worry about all
the little files.)



gwenwifar wrote:

mom is an accountant and works with lots of spread sheets - one of the
project managers, who is not very computer savvy at all, accidentally saved a
huge (and important) spreadsheet as a web document. Windows broke it up into
a whole web, making each page of the spread sheet its own file and the bar
into the navigation. So now there are some 60 files instead of one and of
course, the formulas and things are probably gone. Since i'm pretty good at
computers (though i haven't used excel is ages), i was asked to see if i
could help. I assumed that if excel can create these web files, it should be
able to open them, but when i tried, it kept trying to find the "big" file
and would not open any of the individual web pages. Any ideas? can it be
reconverted? are the formulas even still there?
Thank you very much for any help you can provide,


--

Dave Peterson


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com