Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh columns not in query
Is it possible to refresh added columns on a worksheet when the columns
included in the query are refreshed? For instance, I import items along with description, cost, vendor item number, etc. Then next to that I will add columns calculating gross margin, % of increase, etc. also for each item. If that item has been deleted, it will be deleted after refresh, but the data I have added for that item in the columns next to it still remain on my worksheet. Is there a way I don't have to go in and manually change those columns not in the query? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh columns not in query
Most people have calculation set to Automatic, which means you have to
do nothing. Try F9 otherwise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query Refresh | Excel Discussion (Misc queries) | |||
Query refresh | Excel Discussion (Misc queries) | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |