ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   When opening-file format is not valid (https://www.excelbanter.com/setting-up-configuration-excel/40309-when-opening-file-format-not-valid.html)

Blair

When opening-file format is not valid
 
Every time I open Excel I get the following message"Book.doc. File format is
not valid
How do I get rid of this?
Blair



Dave Peterson

..doc files are usually associated with MSWord.

Try opening that .doc file in MSWord.

==========
Ahhhh.

You're not opening a file named book.doc (at least not on purpose).

You could have book.doc in your XLStart folder.
Use windows start button|search to find XLStart (or book.doc). Then either move
that file out of that folder or delete the file. (I'd move it and then open it
in MSWord to see if was important.)

Or you could have put that .doc file into a special folder:

Inside excel
tools|options|general tab
"at startup, open all files in:" <xl2002+ wording
"Alternate Startup File location" <before xl2002 wording

If you have a folder name in that box, go to windows explorer and move book.doc
out of that folder.

Most people don't have anything in that setting. You may just want to remove
that entry (erase the setting--don't delete the folder).


Blair wrote:

Every time I open Excel I get the following message"Book.doc. File format is
not valid
How do I get rid of this?
Blair


--

Dave Peterson

Andy Wiggins

A .doc file is usually a Word file so try opening it in Word.

Excel files are .xls

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Blair" wrote in message
...
Every time I open Excel I get the following message"Book.doc. File format

is
not valid
How do I get rid of this?
Blair





Blair

Thanks for your help.
I must have tried to open this Word file in Excel. In fact I didn't need
this file so I deleted it and cured the problem
Blair

"Dave Peterson" wrote in message
...
.doc files are usually associated with MSWord.

Try opening that .doc file in MSWord.

==========
Ahhhh.

You're not opening a file named book.doc (at least not on purpose).

You could have book.doc in your XLStart folder.
Use windows start button|search to find XLStart (or book.doc). Then

either move
that file out of that folder or delete the file. (I'd move it and then

open it
in MSWord to see if was important.)

Or you could have put that .doc file into a special folder:

Inside excel
tools|options|general tab
"at startup, open all files in:" <xl2002+ wording
"Alternate Startup File location" <before xl2002 wording

If you have a folder name in that box, go to windows explorer and move

book.doc
out of that folder.

Most people don't have anything in that setting. You may just want to

remove
that entry (erase the setting--don't delete the folder).


Blair wrote:

Every time I open Excel I get the following message"Book.doc. File

format is
not valid
How do I get rid of this?
Blair


--

Dave Peterson





All times are GMT +1. The time now is 05:44 AM.

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