Pivot Table Source Link changed when file saved to SharePoint site
 

I have a pivot table with the source as a named range within my workbook.
When i save the workbook to a sharepoint site, the pivot table source URL
shows the entire path + the named range. How do I ensure that the link
remains intact with the current file and not to the sharepoint site? I've
now saved the file on my desktop and it's still trying to link to the
sharepoint site.

Thanks,
Barb Reinhardt