This is not VBA as you mentioned, but you should just be able to key in the member name in your spreadsheet, and hit the Rebuild Quick View button.
If you're adding a new row or Column dimension, you will need to identify it first (ie U1#Top). Just make sure you highlight the new member as well as a piece of the existing Quick View and then hit Rebuild, so it knows to associate it with it.
Hi,
I'm not looking to add new rows/columns/dimensions in the Quick View. I have and Excel file with existing Quick Views in multiple tabs where I have to change the period every month for each QV. I'm looking to automate the change of period. So far I have been using Find and Replace for the desired period on Excel and going in each QV to click Rebuild but it is time consuming.
This response to me sounds like you want the quick views on multiple tabs to all update to the same period. Without knowing much more than that, would simply setting the time filter to T#Global suffice? Otherwise, the feedback from db_pdx and BobMarchese should get the job done.
I agree with both solutions but there's an obstacle for the case where users have to go back in files dating from previous months and change to a different time function to catch that previous month. There's a risk that a user might omit to change the periods accordingly.
