Pivot Table Won't Update For Co-worker?

[olimits7]

Hi,

I've never come across this before, I have an Excel file with pivot tables on it; however, when my co-worker opens the file and tries to refresh the pivot it doesn't show the new data that it should update with. He then closes out the file and I open it and refresh and it working properly.

We have the same Excel version, permissions, etc. so I don't know why this isn't working for him. If it works for me, I don't there is an issue with the file.

Has anyone ever experienced this type of issue before? Anything I can try doing to fix this issue for him?

Thank you!

 

[johnny51981]

Does your co-worker receive any kind of message when the Pivot doesn't refresh?

 

[olimits7]

Nope, nothing. It looks like it refreshes normally but then when I look at the filter to check ON any new data it doesn't show; but then I do the same exact thing from my PC and it works fine...so strange.

 

[johnny51981]

Does the data used for the PivotTable have any external links?

 

[olimits7]

Yes, the data gets pulled from a file from an external link; however, he has access and same permissions to the same file on the network drive. We even tried having both files open at the same time on his PC and refreshing and nothing happens.

 

[johnny51981]

Ok. Is the External Link that is being used set up with the full network path OR using the mapped equivalent?

Example:
Full
\\MainServer\Reporting Team\Reports\DataFile.csv

vs
Mapped
G:\Reports\DataFile.csv

 

[olimits7]

Yes, it's using a mapped letter drive and we're both mapped to the same letter (e.g. O:\ ). Ty for your help trying to figure this out.

 

[johnny51981]

Maybe for testing sake, set it up as the full network path, just in case there is something a little wonky, even though you are both mapped to the same lettered drive.

The only other thing I would suggest is to check the Calculation settings, is it set to Manual or Immediate. Sometimes that can be changed by a Phantom.

I can't think of any other reasoning why it isn't refreshing the source data.

 

[olimits7]

Ok, thanks...I'll give that a try and see what happens.

 

[olimits7]

Update: So I had him try to link the pivot to the "full" path and strangest thing it did not let him click the OK button to finish updating the link. He then closed out of the file and I went in and tried doing the same thing and it worked for me.

He's able to make other changes to the file (add / delete data) and save the file so I don't know why it's not letting him update the link location. I'm leaning towards some type of permissions issue but don't know where to look since he does have "full access" to this file.

Thank you!