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 4 months 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 year ago

  • 1
Photo of Rav

Rav, Community Manager

  • 89,242 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 Michelle

Michelle

  • 492 Points 250 badge 2x thumb
Hey Karen, is this still happening to you?  It is still happening to me, and is driving me crazy!  I couldn't finish my cashflow reporting last week because of it.  No matter how many times I logged in and out, it still wouldn't work :(
Photo of Kate

Kate

  • 400 Points 250 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.
Did this issue ever get resolved, I have just starting having the same issue!


Photo of DAR

DAR

  • 328 Points 250 badge 2x thumb
Hi Kelly,

I've run into the same issue and applied Kate's solution above.

Odd.

Cheers