Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2013, 07:46 AM
lkernen lkernen is offline File extension issues Windows 7 32bit File extension issues Office 2010 32bit
Novice
File extension issues
 
Join Date: Nov 2013
Posts: 1
lkernen is on a distinguished road
Default File extension issues


The file you are trying to open Form 3 income analysis.xls, is in a different format than specified by the file extension. I started getting this message yesterday when I try to open an existing Excel file. If I create a new Excel file and save it I can open it with no problem.
Reply With Quote
  #2  
Old 11-11-2013, 04:12 AM
macropod's Avatar
macropod macropod is offline File extension issues Windows 7 32bit File extension issues Office 2010 32bit
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

Are you sure the file isn't an xls file or and xlsm file with an xlsx extension? Have you tried changing the extension to xls & xlsm to see whether it opens correctly in either of those formats?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-11-2013, 07:31 AM
BobBridges's Avatar
BobBridges BobBridges is offline File extension issues Windows 7 64bit File extension issues Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Do you see this message when opening a workbook on this forum, or on your own PC? I see it on this forum all the time; it happens when someone uploads a workbook named something.xlsx. This board renames it something.xlsx.xls, and then when I open it I get a warning message because it's named .xls but it's actually an .xlsx.
Reply With Quote
  #4  
Old 11-11-2013, 02:29 PM
macropod's Avatar
macropod macropod is offline File extension issues Windows 7 32bit File extension issues Office 2010 32bit
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 BobBridges View Post
when someone uploads a workbook named something.xlsx. This board renames it something.xlsx.xls
The board software does not rename files. What sometimes happens is that people who have the Windows Explorer 'Hide extensions for known file types' option checked add their own extensions (which actually become part of the filename, not its true extension). When such files get uploaded, the true extension is revealed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-11-2013, 03:49 PM
BobBridges's Avatar
BobBridges BobBridges is offline File extension issues Windows 7 64bit File extension issues Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I'm willing to stand corrected ... but I don't think I get it yet. I just selected and uploaded two workbooks, one named x.xls and the other x.xlsx. I selected them both simply by clicking on them in the File-Upload dialog; I didn't type anything additional in the filename text box. When I open the first, it opens normally in my Excel 2010 without complaint. When I click on the second, I get this message: "The file you are trying to open, 'x.xlsx-1.XLS', is in a different format than the one specified by the file extension...." and so on. When I open that one anyway and then offer to save it, it wants to save it as "Copy of x.xlsx-1.xlsx".

I may be mistaken about what MSOfficeForums.com is doing, but it seems to me it's surely doing something that isn't completely correct.
Attached Files
File Type: xls x.xls (153.0 KB, 10 views)
File Type: xlsx x.xlsx (11.9 KB, 12 views)
Reply With Quote
  #6  
Old 11-11-2013, 04:53 PM
macropod's Avatar
macropod macropod is offline File extension issues Windows 7 32bit File extension issues Office 2010 32bit
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

Both of your attachments save with the extensions that appear here and open correctly for me.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 11-11-2013, 05:17 PM
BobBridges's Avatar
BobBridges BobBridges is offline File extension issues Windows 7 64bit File extension issues Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Hm. I'm not sure what to make of that. A few grasping-at-straws questions:

1) What version of Excel are you using? I would normally assume 2010, but since there's apparently a difference....

2) By "opens correctly" you mean without that warning message that some of us get, right?
Reply With Quote
  #8  
Old 11-11-2013, 09:41 PM
macropod's Avatar
macropod macropod is offline File extension issues Windows 7 32bit File extension issues Office 2010 32bit
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

I have both Office 2003 and 2010 installed on my system. That, however, has nothing to do with how the files are downloaded - that's an entirely web-browser and user issue. By "opens correctly" I mean without any file format warning message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 11-12-2013, 01:17 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline File extension issues Windows 7 64bit File extension issues Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by BobBridges View Post
I'm willing to stand corrected ... but I don't think I get it yet. I just selected and uploaded two workbooks, one named x.xls and the other x.xlsx. I selected them both simply by clicking on them in the File-Upload dialog; I didn't type anything additional in the filename text box. When I open the first, it opens normally in my Excel 2010 without complaint. When I click on the second, I get this message: "The file you are trying to open, 'x.xlsx-1.XLS', is in a different format than the one specified by the file extension...." and so on. When I open that one anyway and then offer to save it, it wants to save it as "Copy of x.xlsx-1.xlsx".

I may be mistaken about what MSOfficeForums.com is doing, but it seems to me it's surely doing something that isn't completely correct.
Things are exactly the same for me as for Bob. When I open files on other forums ( EF, CC, MrE,Ozgrid, Excelguru) the files always open normally.
Very strange
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #10  
Old 11-12-2013, 12:32 PM
BobBridges's Avatar
BobBridges BobBridges is offline File extension issues Windows 7 64bit File extension issues Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Quote:
Originally Posted by macropod View Post
[Excel version] has nothing to do with how the files are downloaded - that's an entirely web-browser and user issue.
Ok, let's pursue that. Pecoflyer sees the same warning message I do, but not macropod; some users report my problem, and presumably some of those who are silent share macropod's experience. I'm using Firefox; Peco and macropod, what are you two using?
Reply With Quote
  #11  
Old 11-12-2013, 12:37 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline File extension issues Windows 7 64bit File extension issues Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

I also use FF, but again, I have no problems on other forums
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #12  
Old 11-12-2013, 01:17 PM
macropod's Avatar
macropod macropod is offline File extension issues Windows 7 32bit File extension issues Office 2010 32bit
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

I use Internet Explorer.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
File extension issues MIX extension convert to jpg gg80 Drawing and Graphics 11 08-10-2018 10:43 AM
File extension issues excel cannot open the file .xlsx because the file format or file extension is not val teddysika Excel 1 11-22-2012 06:06 AM
Getting COMException Incompatible file type and file extension sbalerao Mail Merge 0 04-21-2011 10:30 AM
MS Office Extension chrisr Office 0 03-15-2010 12:25 AM
Movie File Issues - Wont Play Correctly titanxt PowerPoint 0 03-03-2009 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 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