N
Nadine
Running XL 2007 SP1 on Vista SP1, on a office network
Try File open and repair of .xlsx files, receive error:
Excel cannot open the file "filename.xlsx" because the file format or file
extension is not valid. Verify that the file has not been corrupted and that
the file extension matches the format of the file.
Tested on several computers all the same, but if do it on an .xls file no
problem, if convert same file to 2007 using the convert up function, save,
close then try file open repair then get error.
Tested by just creating a blank document, typed word test, saved it as excel
2007, closed, then file open and repair, get message.
Tested same on multiple computers, EXCEPT for ONE it works with no problems,
even on all of the exact same files. Compared all the excel options all
exactly the same.
Checked file type associations all the same.
Could it be a word option affecting the excel?
Tried test by turn option for DDE on and off, doesn't work
found one option that works on some of computers- Exel Options, Advanced,
General. Show add-in user interface errors.
But there is no difference between the computers for add-ins all only have
the adobe pro add-in
If check that option sometimes it works, if uncheck sometimes work.
Yet the one working computer the open repair works doesn't make a difference
if the DDE or the Show error is checked or unchecked both work either way.
Can't find any difference on that one computer compared to all the other
computers. No special software installed, no extra add-ins, nothing
Noticed on the computer that it does work on, get the regular repair message
when it opens the repair, and click to view log..... file located
c:\users\username\appData\local\temp\error###.xml
We checked permissions on the temp folder all have full permissions.
cleaned out all temp files off computer and cleaned out that temp folder.
thinking that since the other computers were not getting that pop up message
maybe it was a permission issue on the folder, or file type association, but
when compared to the computer it works on they are all the same settings.
Any ideas
Thanks
Nadine
Try File open and repair of .xlsx files, receive error:
Excel cannot open the file "filename.xlsx" because the file format or file
extension is not valid. Verify that the file has not been corrupted and that
the file extension matches the format of the file.
Tested on several computers all the same, but if do it on an .xls file no
problem, if convert same file to 2007 using the convert up function, save,
close then try file open repair then get error.
Tested by just creating a blank document, typed word test, saved it as excel
2007, closed, then file open and repair, get message.
Tested same on multiple computers, EXCEPT for ONE it works with no problems,
even on all of the exact same files. Compared all the excel options all
exactly the same.
Checked file type associations all the same.
Could it be a word option affecting the excel?
Tried test by turn option for DDE on and off, doesn't work
found one option that works on some of computers- Exel Options, Advanced,
General. Show add-in user interface errors.
But there is no difference between the computers for add-ins all only have
the adobe pro add-in
If check that option sometimes it works, if uncheck sometimes work.
Yet the one working computer the open repair works doesn't make a difference
if the DDE or the Show error is checked or unchecked both work either way.
Can't find any difference on that one computer compared to all the other
computers. No special software installed, no extra add-ins, nothing
Noticed on the computer that it does work on, get the regular repair message
when it opens the repair, and click to view log..... file located
c:\users\username\appData\local\temp\error###.xml
We checked permissions on the temp folder all have full permissions.
cleaned out all temp files off computer and cleaned out that temp folder.
thinking that since the other computers were not getting that pop up message
maybe it was a permission issue on the folder, or file type association, but
when compared to the computer it works on they are all the same settings.
Any ideas
Thanks
Nadine