I always login to Excel, then Data Dear and all my data is refreshed automatically. However recently I have not managed this. One of the tables “Invoice Lines” when refreshed it is refreshed by Invoice/Credit Note Lines instead - which has 34 extra fields.
If I then refresh is back to “Invoice Lines” - all my references in Excel are broken and don’t work. I will then need to check all the formulas in my Excel - ARRRRRGH!
I also cannot change the refresh before it does perform the refresh. This is because as soon as I click logon - it refreshes.
ANY HELP IS MUCH APPRECIATED?