Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2022, 06:18 PM
Windspeed Windspeed is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 7 32bit Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2007
Novice
Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word)
 
Join Date: Jun 2017
Posts: 7
Windspeed is on a distinguished road
Default Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word)

Each time I open Excel 2010 I get a message saying 'Normal.dotm: File format is not valid'. I simply click 'ok' and it goes away and all is fine. This does not appear when I open Word where all seems to be fine.
Any suggestions?
Thanks
Reply With Quote
  #2  
Old 05-26-2022, 12:20 AM
wiganken wiganken is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 11 Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Have you by chance copied the normal.dotm Word template into the following location: -

C:\Users\Your User Name\AppData\Roaming\Microsoft\Excel\XLSTART

If so then delete that normal.dotm file.
Reply With Quote
  #3  
Old 05-26-2022, 08:11 AM
macropod's Avatar
macropod macropod is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 10 Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Windspeed View Post
Each time I open Excel 2010 I get a message saying 'Normal.dotm: File format is not valid'.
That suggests someone has configured your Excel application so that it tries to open 'Normal.dotm' - a Word template - instead of an Excel template.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-26-2022, 11:50 PM
wiganken wiganken is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 11 Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Just for the record 'Normal.xlsm' is not a template. See Change the default file format for saving workbooks . It is a macro-enable Excel workbook format.

Also I don't see how anyone could edit the MS 'Excel.exe' file to force it to use the Normal.dotm Word template. Excel uses the templates 'Book.xltx' and 'Sheet.xltx' stored in the XLSTART folder when it launches.

It would be interesting to see if @Windspeed finds a solution and what it was. Are you watching OP?
Reply With Quote
  #5  
Old 05-27-2022, 07:09 AM
Debaser's Avatar
Debaser Debaser is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 7 64bit Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

There is also another XLSTART folder in the Program Files\microsoft Office\Officenn folder, and you can configure a further startup folder in Excel options, so it may be worth checking those too.
Reply With Quote
  #6  
Old 05-28-2022, 07:34 AM
wiganken wiganken is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 11 Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

@Debaser - You state "There is also another XLSTART folder in the Program Files\microsoft Office\Officenn folder" . There isn't a second XLSTART folder on my machine? I have looked in both 'Program Files' and 'Program Files (x86)' folders.

Just thought I would mention this in case other people look and don't find it. It may depend upon the version of Office that is installed?
Reply With Quote
  #7  
Old 06-06-2022, 02:33 AM
Debaser's Avatar
Debaser Debaser is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 7 64bit Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

It seems to have been moved, at least for 365, to Microsoft Office\root\Office16
Reply With Quote
  #8  
Old 07-17-2022, 08:41 PM
Windspeed Windspeed is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 7 32bit Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2007
Novice
Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word)
 
Join Date: Jun 2017
Posts: 7
Windspeed is on a distinguished road
Default

Ok, more investigation reveals that the "Normal.dotm: File format is not valid" message happens when I try to open Excel on any of 3 different computers. Therefore the offending version of file 'Normal.dotm' must be somewhere common to all 3. The main possibility was Dropbox so I searched there and, surprise surprise, there is a version of the file. (I assume this is not where it is supposed to live?) So I deleted the file (hang the consequences, lets live dangerously!) then opened Excel on each of the 3 computers. No message. All good so far. But each time I've done this over the last month, it has reappeared a few days later, I think when I create a new file with Word...I'll test that over the next few days and report back. The bigger mystery still remains why Excel goes looking for or is sent to a Word 'template' instead of the excel version of template. Have I pointed it in the wrong direction at some stage perhaps? I'll keep looking and report back. Thanks
Reply With Quote
  #9  
Old 07-18-2022, 07:37 AM
macropod's Avatar
macropod macropod is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 10 Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As has already been said, Normal.dotm is not an Excel file - it's a Word file.

Having a copy of Normal.dotm on Dropbox is of no consequence in and of itself. What might matter is whether Excel has been configured to use as its XLSTART folder the same folder that Word has been configured to store its Normal template in.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 07-19-2022, 09:23 AM
kilroyscarnival kilroyscarnival is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 10 Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Windspeed View Post
Ok, more investigation reveals that the "Normal.dotm: File format is not valid" message happens when I try to open Excel on any of 3 different computers. Therefore the offending version of file 'Normal.dotm' must be somewhere common to all 3. The main possibility was Dropbox so I searched there and, surprise surprise, there is a version of the file. (I assume this is not where it is supposed to live?) So I deleted the file (hang the consequences, lets live dangerously!) then opened Excel on each of the 3 computers. No message. All good so far. But each time I've done this over the last month, it has reappeared a few days later, I think when I create a new file with Word...I'll test that over the next few days and report back. The bigger mystery still remains why Excel goes looking for or is sent to a Word 'template' instead of the excel version of template. Have I pointed it in the wrong direction at some stage perhaps? I'll keep looking and report back. Thanks
When you go into Word, and go into File/Options/Save, is there a path to the Dropbox folder somewhere it maybe shouldn't be? Even then, I can't account for it writing the Normal.dotm file there.

On the Dropbox side, you have the desktop app version of Dropbox? Does it have entire folders set to automatically back up there? If so, you might have it pointed at the Program Files\ area which isn't a great idea.
Reply With Quote
  #11  
Old 08-03-2022, 04:29 PM
Windspeed Windspeed is offline Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Windows 7 32bit Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Office 2007
Novice
Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word)
 
Join Date: Jun 2017
Posts: 7
Windspeed is on a distinguished road
Default

Just a followup: The problem of "Normal.dotm: File format is not valid" seems to have gone away since I deleted the Normal.dotm file in Dropbox. So, fingers cross I've solved it. Thanks for your help and suggestions. enjoy...
Reply With Quote
Reply

Tags
excel 2010, file format is not valid, normal.dotm

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) I have duplicate Normal.dotm files and get an Excel error message that it is not a valid file type Windspeed Word 4 07-17-2022 08:36 PM
Format file not valid in Excel Harrington48 Excel 2 10-21-2021 06:30 PM
I have a dotm file and can't add bookmarks because it reverts to normal doc Dpucher Word VBA 1 07-21-2019 08:15 PM
Excel gives Normal.dotm: File format is not valid message (yes, Excel, not Word) Convert word file into more readable format to paste into Excel jeffreybrown Word 8 02-27-2018 05:34 AM
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open kdash Word 0 05-06-2015 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft