Exclude Network Path In PivotTable Based on Sharepoint
 

I have an excel file linked to a sharepoint 2007 network space. Everytime I
open the file, my pivot tables will not refresh, because the source of the
pivottable seems to update automatically to include the network drive name on
them which somehow causes a problem. Is there anyway to solve this? I put a
snippet of the source in the pivottable as an example.

"http ... /PMO/Shared%20Documents/
Finance/Budget/2008/2008%20What%20If%20Budget.xls'!=WhatIf"

The problem is that all the text prior to the "=WhatIf" causes the formula
to break. When I attempt to refresh the data, excel spits out an error
"Cannot open PivotTable source file '2008%What%If%Budget.xls'"

Exclude Network Path In PivotTable Based on Sharepoint
 

"eduboys" wrote:

I have an excel file linked to a sharepoint 2007 network space. Everytime I
open the file, my pivot tables will not refresh, because the source of the
pivottable seems to update automatically to include the network drive name on
them which somehow causes a problem. Is there anyway to solve this? I put a
snippet of the source in the pivottable as an example.

"http ... /PMO/Shared%20Documents/
Finance/Budget/2008/2008%20What%20If%20Budget.xls'!=WhatIf"

The problem is that all the text prior to the "=WhatIf" causes the formula
to break. When I attempt to refresh the data, excel spits out an error
"Cannot open PivotTable source file '2008%What%If%Budget.xls'"

bump - Any way to solve this without creating a macro to update the source
data for all of the pivots in my workbook?