Hi,
I have a table in one excel sheet (which is located on a shared drive). This table has around 30,000 rows and is updated with new information every day (around 50 rows worth is added every day), using VBScript.
I have successfully imported this information into a local workbook, which is fine, however I am encountering errors with this when I try to refresh.
When I do not have the original workbook open, I am greeted with an error when trying to refresh - shown below.
exceltableerror.png
Transcribed - "We couldn't get the data from 'Table2' in the workbook [path blanked for privacy]. Open this workbook in Excel and try again."
When I do have the original workbook open, the data refreshes fine. Whilst I am thinking the other solution is to create a VBScript that opens both workbooks, updates the second one, then closes both workbooks, this is not really the ideal solution.
Some housekeeping - I have 100% ensured the correct workbook is being referenced, also, this would give the "workbook not found error".
Can anyone help explain why i'm seeing this error? I've done a fair bit of googling, and many people are referring to power pivots/tables, however i am on 2013 and not using these methods.
Thanks in advance.
Bookmarks