I have another problem to report which only happened today.
I uploaded a .xlsx file (Excel Workbook) and under the File Attachments it’s display as a .xlsx file ok but when I click on it to open it up from the forum after uploading I get the following message -:
As you can see below from the post the file is a .xlsx file -:
If I click YES the file opens fine and I have both xls and xlsx in the File Uploads > File Types
Confused as to why this is happening and hope you can shed some light on it.
afraid that error has nothing to do with simple press… its an MS Excel error… and long after any upload or download interaction…
MS doesnt believe its an excel file… rather than opening direct, try downloading it and see if it will open…
I just ran some tests and there is no issue with uploading or download of MS office files…
It’s weird because I’ve been doing the exact same thing for the last 10 days uploading as .xlsx and every time before today it worked fine and downloaded it as a .xlsx – the only changes I made were not excel-related but forum related with the permissioning to try to allow people to subscribe to read only topics so I thought it would be something to do with that – nothing else has changed on the site so I’m really confused as to why this would suddenly go wrong as I’ve tested in IE and Chrome. Maybe I will try just uploading it in a .zip file but it’s one extra step in the process…grrr..why can s/w just not play nicely together !
The bottom line I think you will find is it up to the receiving program (in this case Excel) to identify the file extension and file type. Nothing else gets involved.
The bottom line I think you will find is it up to the receiving program (in this case Excel) to identify the file extension and file type. Nothing else gets involved.
It still doesn’t explain though why it identified it as .xlsx last 10 days until today – Guess I go down the zip route.
its a good question… and of course we dont alter the extension or file contents… is it happening for all .xlsx files or just the one? I have uploaded and read no less than six testing it out on multiple sites…
Mr Papa said
its a good question… and of course we dont alter the extension or file contents… is it happening for all .xlsx files or just the one? I have uploaded and read no less than six testing it out on multiple sites…
It’s doing it for all of them, very confusing.
After much playing I found the culprit was a rewrite rule checkbox on the W3 Total Cache Plugin under the Miscellaneous setting which may be something to bear in mind if anyone else raises a similar query.
Yellow Swordfish said
Curious. What is it for?
Not sure as didn’t delve but when I uncheck it works as .xlsx, re-check then it breaks and changes to .xls on download ! It says the following -:
Notify of server configuration errors, if this option is disabled, the server configuration for active settings can be found on the install tab.
I recently setup a CDN…I guess it is best to exclude /forum seeing as how its dynamic and so pointless caching ?
not entirely… CDN of images would still potentially help… and object caching can work… but caching static html will not work…