Excel 2007 saving in wrong format?

B

Biggar

I have several users who are saving documents by clicking on the Save As (the
default is Excel 97-2003) filling in the name and clicking save. When they
try to open the document from Windows Explorer they receive the error "Excel
cannot open the file because the file format or file extension is not valid".
They are using Office 2007 and the file has been saved with the XLSX
extension. If I change the extension to XLS they are able to open the file.
At first I thought user error, but three different users? We also have
another user with the similar problem in Word 2007.
 
J

Jan Karel Pieterse

Hi Biggar,
They are using Office 2007 and the file has been saved with the XLSX
extension. If I change the extension to XLS they are able to open the file.
At first I thought user error, but three different users? We also have
another user with the similar problem in Word 2007.
Click to expand...

Not sure what causes the problem, but I'd suggest to look over the shoulder of
one of your users when he/she does a save-as. Check what extension is given/used
to the file.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
S

Shane Devenshire

This is probably a File Association error:

try right-click the file, select "Open With" select microsoft excel 2003
and check, or not, always use this program.
 
B

Bonnie

Can you explain to me how to change the file extension? I just clicked on
the save (it might have said "save as" but I didn't notice) dialog box and
thought I was saving a minor change. When I tried to open the file later, I
too got the "cannot open file because the file format or file extension is
not valid".
How do I change the extension to .xls from the .xlsx so I can open the file.
Thanks
 
S

Sean Frisbey

However, if they have extensions hidden, go to Windows Explorer, click Tools
-> Folder Options. Under the View tab, uncheck the box that says "Hide
extensions for known file types."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Save workbook without shapes 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Apply Excel Macros to another open file 1
Excel 2007 corrupts XLSX files when password is used - all compute 2
Excel 2007 corrupt files 1
VBA - exporting serial letters to single documents 0
File format is not valid 1

Top