>Hello,
>I show Excel chart on VFP forms with OleBoundControls. It works fine, until come Excel 2016 and higher.
>lcF= some excel file
>create cursor bla (bla g)
>append blank
>append general bla from (lcF)
>thisform.oleboundcontrol1.ControlSource="bla.bla"
>thisform.oleboundcontrol1.refresh()
>This code executes quickly and in excel prior 2016 show in 1 second.
>But in new excel it takes 10+ seconds.
>Now are all PCs in my company new and modern :(
>Is there any vfp solution ?
This is not a solution. I've noticed that sometimes when using Excel, first workbook opens immediately. Opening second or subsequent ones can take a long time.
You might try making sure you have only one instance of Excel running at any given time, see if that makes any difference.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up