Nikhil Patki
New member
I have excel sheet created in my office desktop
also created a pivot table using the Data from the file in other sheet of same file.
having some extra work i transferred the excel workbook to my home desktop using whatsapp message.
but when i finished my work in the workbook I tried to refresh the Pivot table to see updated numbers.
but excel provided an error to update data stating the original file path that was of my office desktop.
same error had arrived when i initially opened the workbook on my system.
Using a normal Excel table and pivot table created from the data of the table
why excel is showing me office desktop path of file is a very surprising thing for me.
I hope I would get a proper clarification regarding this error and also my doubt
also created a pivot table using the Data from the file in other sheet of same file.
having some extra work i transferred the excel workbook to my home desktop using whatsapp message.
but when i finished my work in the workbook I tried to refresh the Pivot table to see updated numbers.
but excel provided an error to update data stating the original file path that was of my office desktop.
same error had arrived when i initially opened the workbook on my system.
Using a normal Excel table and pivot table created from the data of the table
why excel is showing me office desktop path of file is a very surprising thing for me.
I hope I would get a proper clarification regarding this error and also my doubt