Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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'" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot copy PivotTable to Network, at work. | Excel Discussion (Misc queries) | |||
user cannot access his share workbook after opening network path. | Excel Discussion (Misc queries) | |||
Path to a network drive | Excel Discussion (Misc queries) | |||
Pivottable - Accessing file from network | Excel Discussion (Misc queries) | |||
Pivottable across network | Excel Worksheet Functions |