Re: Refresh a table in excel with VBA
Hi Paul,
Can you please provide more information as of how you are doing this?
I mean, are you importing data using MySQL for Excel, then hiding the Worksheet and then attempting to refresh it?
Are you using VBA code to call the ThisWorkbook.RefreshAll?
Maybe the MySQL for Excel add-in is preventing the hidden worksheet from being refreshed. If you pulled the data WITHOUT MySQL for Excel, you could try disabling the add-in to see if it is messing with the way Worksheets are refreshed. If you pulled the data using MySQL for Excel and you can consistently reproduce this, please raise a bug report at
https://bugs.mysql.com.
Best regards.
====================================
Javier Treviño
MySQL on Windows Team
Subject
Views
Written By
Posted
1511
December 04, 2017 05:33AM
Re: Refresh a table in excel with VBA
1080
January 09, 2018 07:17PM
926
January 09, 2018 07:30PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.