Refresh columns not in query

  • Thread starter Thread starter vburns
  • Start date Start date
V

vburns

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?
 
Most people have calculation set to Automatic, which means you have to
do nothing. Try F9 otherwise.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Pivot table refresh problem 2
v lookup multilple columns 3
Pivot Table Refresh Not Updating Drop Down List 1
Aligning Two Columns by common number 2
comparing data in excel 3
Automatic refresh in linked worksheet if row is added 1
Want only rows with populated data 1

Back
Top