Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I set up a pivot table based on data in a web query. I added a few helper columns to the right of the web query data that apply formulas to data from the web query and place the results in the helper column, which is then also used in my pivot table. Is it possible to have the information in these helper columns update automatically when the web query updates? Currently I need to reapply the formulas in the column by dragging the forumla from the first cell in the column down to the bottom of the web query range. Thanks, Tom |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation function with helper column | Excel Worksheet Functions | |||
HOW DO I GET COLUMN TOTALS TO AUTO UPDATE? | New Users to Excel | |||
Changing the Helper Column | Excel Discussion (Misc queries) | |||
What is a helper column? | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |