I have a sheet containing three tables. One table imports prices from another sheet using vlookup. I would like one column in that table to not update until I command it to using a macro. I do not want to set the entire sheet to manual calculation.
Suggestions would be appreciated.
I believe that the functionality of Excel is an all or nothing scenario when it comes to calculation.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Yeah, that's what I figured, just wondered if anybody has a work around. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks