I have a complex Excel worksheet and I want to populate some of the cells with Impromptu data. I added the worksheet as an OLE object in Impromptu and I am able to place query items on top of the worksheet so that it looks like the Excel worksheet contains the data. What I want to do is have Excel use those query items when calculating formulas in other cells.
Using Impromptu 7.4. Is there a way to do this?
Thanks so much for the help.
Hank