Hello,
I realize these types of questions are difficult if not impossible to diagnose but are there any settings in calc that might be causing things to import slowly during a refresh from a sql server instance? We have a import from a table with 5,000 rows and maybe 30 columns of varchar (25) which is taking 5+ minutes to do a data refresh. Are there some common problems that we could look into to possibly fix to speed things up?
Thank you!