"re-import data using current configuration" auto refresh, with multiple excel files

Liam shared this question 2 months ago
Discussion Open

I currently have a Mindmap with 20+ different excel files all linked and I would like to refresh these excel docs on a daily basis as they are constantly being updated. However the only way i can seem to do this is by right clicking each one individually and clicking "re-import data using current configuration".

Is there a way to do this within the software? I have tried to create a macro and keep getting hung up, tried some troubleshooting with Chatgpt but did not result in any good results.

Any ideas on how to automate this?

Replies (1)

photo
1

Business Topics are typically refreshed by pressing F5. Does this work in this instance?

photo
1

I gave that a shot with "f5" and "shift+f5" it did not update.

photo
1

That's a pity. It might be possible through the API, but it would require some experimentation as this is not a published interface as far as I am aware.

photo
Leave a Comment
 
Attach a file