MySQL Forums
Forum List  »  MySQL for Excel

Re: Refresh a table in excel with VBA
Posted by: Javier Treviño
Date: January 09, 2018 07:17PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
972
December 04, 2017 05:33AM
Re: Refresh a table in excel with VBA
782
January 09, 2018 07:17PM
644
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.