• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 120
  • Last Modified:

Excel 2013 issues when saving as CSV format

Have an issue with saving CSV file on a domain joined PC. User attempts to save Excel file in CSV format, results in Excel dialogue
"(random).tmp cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only"
You can hit retry all you want, it doesn't go away. If you hit cancel and attempt to save it again, it will work. If i save the same file as a .xlsx format, no issues. Not an issue if I login to the PC as local user and create/save file on local drive but will have same issues if i connect to the network share manually and attempt to save the file. Its only affecting .CSV files.
Have done the following:
Check NTFS permssions on folder, check Excel setting with regards to trusted network locations, performed Office repair (reinstall)
Able to recreate exact same issue on another workstation with same environment.
Running Win7Pro on a domain with Office 2013 (Version 15.0.4997.1000)
Not an issue with Excel 2016 (tested)
1 Solution
It seems the Windows 7 tries to write the file to the offline file cache.

You should disable Windows 7  offline file cache (It's enable by default)
MelissaSystems AnalystAuthor Commented:
Zvitam - yes that resolved my issue.
Any idea why this would cause this and how would one make an exception to allow offline files facility to still be on?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now