I have a pivot table in one workbook whose source data is in another workbook. If I move the source file the second file gives me an error message because it can't find the pivot table. I'm glad that appeared now. I will be distributing this setup to another user who will do the same thing I do for the other half of the company.

I'd like to make it so the pivot table will update as long as the source workbook is in the same folder as the destination. That way I can put THEM BOTH on my desktop while my friend puts them in a folder off the C drive if he wants to.

Is this possible? If not I will have to merge the two workbooks. Due to the sheer number of formulas and macros each book has that might create a few problems on it's own.

I appreciate any discussion. I don't expect anyone to give me a turnkey answer. Whatever you advise that I don't understand will go on my reading list.

many thanks to all.