The database is already on a shared drive. The excel document is located on the shared drive as well, same directory as the database. Like I said, this all worked fine for the last 2 months, until Monday, then the error came up. Since the database is live, and updates are constantly made to it, it's important the users have the ability to refresh the file as necessary.
I've never had this issue before. Any change this might have something to do with Daylight Savings changes?
Quote:
Originally Posted by cori25
Hello...
You can only refresh xls documents on the computer where the database it is pulling the data from is located.
Unless you move the database to a shared drive where all users attempting to refresh the xls have access. If you do this you will have to relink to the table or query where you are getting the data from so that it has the correct path.
I would recommend you leave the database on your c drive or wherever you may have it and have a module run everyday that will run the macro in excel to refresh the document and then send out an email to recipients daily with the updated report.
Hope this helps
