6 Replies Latest reply on Apr 18, 2017 1:59 AM by Mahfooj Khan

    Data sources stored in temporary locations

    Lucie Brett

      Hello everyone,

       

      This is a general query which I have had for a while and wondered if anyone has come across the same thing.

       

      I have a report which I refresh every fortnight, it has a live SQL connection and then it is connected to various Excel files. When it comes to updating the report, I always have to edit the connection of the Excel files to find the original updated source file rather than a temporary file which has been stored somewhere.

       

      Could the reason for this be because I am not extracting the data? Is there a setting which would mean I no longer have to edit the connection again?

       

      Thanks in advance for your advice!