I was trying to combine 2 excels into one, but i had a lot of formulas and pivot tables, so i decided to transfer the tabs from one excel to the other. My issue now is that the other excel is empty and i deleted it, but now i cannot change the data source of the pivot tables nor create new pivot tables because it gives me the error. Sorry cannot find "old file" its possible it was moved or deleted. Please help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
