I am importing several tables from Access into Excel, and then have VBA to automatically calculate some summary statistics for the data. However, I'm having some difficulty with referencing table columns in formulas. I have several columns that are unnecessary to include in Excel, they're automatically deleted. When the table is imported, the formulas on the summary sheet change their references. For example:

What should be 
Please Login or Register  to view this content.
becomes 
Please Login or Register  to view this content.
because Order Volume has shifted over one column to the right (from Col C to D), and Order Date is now in the location Volume should be (moved from Col B to C).

I can't remember ever having this issue before. I thought table references were absolute and shouldn't adjust based on the table columns moving? Is there any workaround? I've tried 
Please Login or Register  to view this content.
but that doesn't do anything in this case.