When I try and save an Excel file to QDrive I'm getting an error message 'Excel could not open data file' then at other times it works ?

  • 1
  • Question
  • Updated 2 weeks ago
  • (Edited)
When I try and save an Excel file to Q Drive I'm getting an error message 'Excel could not open data file' then at other times it works?  This has only started happening over the past week
Photo of Karen

Karen

  • 202 Points 100 badge 2x thumb

Posted 1 month ago

  • 1
Photo of Rav

Rav, Community Manager

  • 57,814 Points 50k badge 2x thumb
Hi Karen,
Can you let me know which format Excel file you're saving into the Q drive? ie. .xlsx or .xls?

You mentioned that at other times it works, on those occasions is there anything you do specifically to make it work? ie. logging out & logging back in etc
Photo of Karen

Karen

  • 202 Points 100 badge 2x thumb
Hi Rav 

I'm using .xls files.  No nothing specific, it wasn't working one day & I had logged on and off a number of times, it then worked the next day.  I have logged on and off today with no success, however I just tried it again and it's worked.  Seems to be random, I'm using Windows 10 with Microsoft 2016 Excel would this having anything to do with it? 

Karen
Photo of Kate

Kate

  • 220 Points 100 badge 2x thumb
I've had the exact same issue. It happens alot when I've exported or emailed a number of excel reports in a row.

The only fix I've found is to go to the Login Screen - Control panel - Log Off Remote Session

This seems to reset it and it will start emailing and exporting in Excel again.