Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File format is not valid
Can anyone help me with this. I tried to open an existing file (which a
number of people have access to) and it has come up with this error. Can it be fixed? Thanks heaps. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File format is not valid
Is it an xls file?
"FB" wrote: Can anyone help me with this. I tried to open an existing file (which a number of people have access to) and it has come up with this error. Can it be fixed? Thanks heaps. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
File format is not valid
Yes. And it worked just fine a week ago prior to someone doing something to
the file. "exceluserforeman" wrote: Is it an xls file? "FB" wrote: Can anyone help me with this. I tried to open an existing file (which a number of people have access to) and it has come up with this error. Can it be fixed? Thanks heaps. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
File format is not valid
One of the bad things about Office is that MSWord can open .xls files. And if
the file is saved as a Word Document (even with a .xls extension), then that file can no longer be opened by excel. Try this against a copy--no sense taking a chance that you'll do more damage. Start up MSWord File|open that copy of your .xls file. If it opens there, then there's a pretty good chance that some user saved it as an MSWord file. You may be able to save a bit of it by just copying and pasting into a new workbook in Excel. But you'll probably have lots of work to do to recreate it (or maybe just restore from a backup???). ===== If that's not it.... Sometimes, you can open files in a later version of excel. (Maybe xl2002, xl2003???) Lots of people have said that they could save a great deal of the data/code using OpenOffice.org. http://www.openoffice.org, a 60-65 meg download or a CD There are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com FB wrote: Can anyone help me with this. I tried to open an existing file (which a number of people have access to) and it has come up with this error. Can it be fixed? Thanks heaps. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
File format is not valid
You are a SUPER STAR. It opened in word and it had all the data in seperate
pages. So thank you. It will take a bit of work to copy and paste but it is doable. It was our lost property log and we have not entirely computer literate people that have to use it. Thanks once again. "Dave Peterson" wrote: One of the bad things about Office is that MSWord can open .xls files. And if the file is saved as a Word Document (even with a .xls extension), then that file can no longer be opened by excel. Try this against a copy--no sense taking a chance that you'll do more damage. Start up MSWord File|open that copy of your .xls file. If it opens there, then there's a pretty good chance that some user saved it as an MSWord file. You may be able to save a bit of it by just copying and pasting into a new workbook in Excel. But you'll probably have lots of work to do to recreate it (or maybe just restore from a backup???). ===== If that's not it.... Sometimes, you can open files in a later version of excel. (Maybe xl2002, xl2003???) Lots of people have said that they could save a great deal of the data/code using OpenOffice.org. http://www.openoffice.org, a 60-65 meg download or a CD There are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com FB wrote: Can anyone help me with this. I tried to open an existing file (which a number of people have access to) and it has come up with this error. Can it be fixed? Thanks heaps. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
File format is not valid
You may want to start making backups of important files. You never know when
things will be gone forever. FB wrote: You are a SUPER STAR. It opened in word and it had all the data in seperate pages. So thank you. It will take a bit of work to copy and paste but it is doable. It was our lost property log and we have not entirely computer literate people that have to use it. Thanks once again. "Dave Peterson" wrote: One of the bad things about Office is that MSWord can open .xls files. And if the file is saved as a Word Document (even with a .xls extension), then that file can no longer be opened by excel. Try this against a copy--no sense taking a chance that you'll do more damage. Start up MSWord File|open that copy of your .xls file. If it opens there, then there's a pretty good chance that some user saved it as an MSWord file. You may be able to save a bit of it by just copying and pasting into a new workbook in Excel. But you'll probably have lots of work to do to recreate it (or maybe just restore from a backup???). ===== If that's not it.... Sometimes, you can open files in a later version of excel. (Maybe xl2002, xl2003???) Lots of people have said that they could save a great deal of the data/code using OpenOffice.org. http://www.openoffice.org, a 60-65 meg download or a CD There are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com FB wrote: Can anyone help me with this. I tried to open an existing file (which a number of people have access to) and it has come up with this error. Can it be fixed? Thanks heaps. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Format of CSV File in export | Excel Worksheet Functions | |||
file format needs to be changed | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |