Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automate query parameter refresh and multiple chart print out
Ok, I have (let me count here...) 7 worksheets in this excel workbook.
I also have 7 charts that run off of each of them. I also have microsoft queries that grab the data.... :( In each query, all of them have the same date period field. In th criteria, they all have the parameter [Enter Period (YYYYMM)]. Is there a way to have a user click a button to refresh all dat worksheets, and only be asked the parameter once? I also want to b able to let the user view each chart and print them all at once. I have done similar work before, and I create a form on a worksheet. Then I have the workbook open to that sheet and it looks like a men for the user. Can someone help me in this process, please? Thanks all! : -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Refresh multiple data connections & pass parameter to S | Excel Discussion (Misc queries) | |||
Parameter Query to return multiple values | Excel Discussion (Misc queries) | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
parameter query - multiple options | Excel Discussion (Misc queries) | |||
Parameter Query-enter just once for use in multiple places | Excel Discussion (Misc queries) |