Question:
HI!! I have to refresh two queries in a workbook at the same time. I know there is a VBA function that allow to do this but (SAPBEXrefresh) but I'm not be able to use it.
Anyone has a solution?
Thanks
Answer:
Neo,
If your active cell in Excell is in the result area of one of your queries, the refresh button in the toolbar will only refresh this query. However, if your active cell is outside the result area of these queries, the refresh button in the toolbar will refresh all queries.
I hope this helps you
kind regards,
bene
Answer:
And how can I define the active cell in Excell?
Thanks!!!
Answer:
Record a simple macro that selects a sheet, then a cell in that sheet.
Copy the code & use it where needed.
Answer:
or just click in a cell outside the query and save as a workbook
_________________
life only sucks when you let it get that way!
Answer:
Put the cursor in any white area of the spreadsheet, then that becomes the active cell and it is outside the results area (like to the right of the filter/drill down area). Then use the Refresh button of the toolbar. Why complicate things when there is a simpler solution? I have power users who use multiple queries in a single workbook and refresh all of them at once.
Another option is make the setting refresh on open, but I guess this works on only one query.
_________________
Keep smiling
Answer:
Refresh on open can be set for each query in the workbook or you can Make the setting and click on Okay for All Queries.
This works for us. We have several workbooks designed with multilple embedded queries.
_________________
Mitchell Lehr
BW - Share the love ><
Answer:
Has anyone had trouble with this? After SP 15 (on version 3.0B) ours no longer works. Even though the selection criteria are identical, the selection screen pops up multiple times. I have searched the forum and OSS but haven't found anything. Any ideas? Is there perhaps a setting we are missing?
Thanks,
LIO