You are reading a single comment by @peter_h and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@peter_h
It might not help the performance (and vlookups with lots of records do slow things down!), but you could write some VBA code which would reset your ranges after pasting new data in and then refresh any pivot tables that referred to them at the click of a button.
How big is the Excel file?