Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > OfficeXP "Cannot open pivot table source file" when refreshing pivot table
 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 1
Default OfficeXP "Cannot open pivot table source file" when refreshing pivot table
Client Context:
WinXP: 5.1.2600 Service Pack 1 Nu 2600
IE: 6.0.2800.1106 SP1
Excel 10.5815.4219 SP2

Server Context:
Win2000 Server+IIS

How to reproduce:

1/ From IE 6.0 Click an hyperlink (with query string part)
on an asp that returns an excel file containing a
PivotTable based on cell range.
2/ Then click on refresh from the PivotTable ToolBar.

This work fine with XL2000.
May be usefull
Asp Code:
<%@ Language=VBScript %
<%
Response.Buffer = false
Response.ContentType = "application/vnd.ms-excel"

Const adTypeBinary = 1
Dim strFilePath
strFilePath = "D:\classeur2.xls"
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open
objStream.Type = adTypeBinary
objStream.LoadFromFile strFilePath
Response.BinaryWrite objStream.Read
objStream.Close
Set objStream = Nothing

%

And here is the excel file:

<?xml version="1.0"?
<Workbook xmlns="urn:schemas-microsoft-
com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset"
xmlns:z="#RowsetSchema"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
<DocumentProperties xmlns="urn:schemas-microsoft-
com:office:office"
<Author </Author
<LastAuthor </LastAuthor
<Created2003-12-04T14:48:47Z</Created
<LastSaved2003-12-04T15:27:52Z</LastSaved
<CompanyDATASET</Company
<Version10.4219</Version
</DocumentProperties
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-
com:office:office"
<DownloadComponents/
<LocationOfComponents HRef="file:///\\"/
</OfficeDocumentSettings
<ExcelWorkbook xmlns="urn:schemas-microsoft-
com:office:excel"
<WindowHeight8070</WindowHeight
<WindowWidth13605</WindowWidth
<WindowTopX0</WindowTopX
<WindowTopY1230</WindowTopY
<ProtectStructureFalse</ProtectStructure
<ProtectWindowsFalse</ProtectWindows
</ExcelWorkbook
<Styles
<Style ss:ID="Default" ss:Name="Normal"
<Alignment ss:Vertical="Bottom"/
<Borders/
<Font/
<Interior/
<NumberFormat/
<Protection/
</Style
<Style ss:ID="s21"
<Borders
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
</Style
<Style ss:ID="s23"
<Borders
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
</Style
<Style ss:ID="s24"
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
</Style
<Style ss:ID="s25"
<Borders
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
<NumberFormat/
</Style
<Style ss:ID="s26"
<Borders
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1"
ss:Color="#000000"/
</Borders
<NumberFormat/
</Style
</Styles
<Names
<NamedRange ss:Name="a" ss:RefersTo="=Feuil1!R1C1:R2C2"/
</Names
<Worksheet ss:Name="Feuil1"
<Table ss:ExpandedColumnCount="5"
ss:ExpandedRowCount="7" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60"
<Column ss:Index="4" ss:AutoFitWidth="0" ss:Width="24"/
<Column ss:AutoFitWidth="0" ss:Width="20.25"/
<Row
<Cell<Data ss:Type="String"a</Data<NamedCell
ss:Name="a"/</Cell
<Cell<Data ss:Type="String"b</Data<NamedCell
ss:Name="a"/</Cell
</Row
<Row
<Cell<Data ss:Type="Number"1</Data<NamedCell
ss:Name="a"/</Cell
<Cell<Data ss:Type="Number"2</Data<NamedCell
ss:Name="a"/</Cell
</Row
<Row ss:Index="4"
<Cell ss:Index="4" ss:StyleID="s21"<Data
ss:Type="String"Somme a</Data</Cell
<Cell ss:StyleID="s23"/
</Row
<Row
<Cell ss:Index="4" ss:StyleID="s21"<Data
ss:Type="String"b</Data</Cell
<Cell ss:StyleID="s23"<Data
ss:Type="String"Somme</Data</Cell
</Row
<Row
<Cell ss:Index="4" ss:StyleID="s21"<Data
ss:Type="Number"2</Data</Cell
<Cell ss:StyleID="s26"<Data
ss:Type="Number"1</Data</Cell
</Row
<Row
<Cell ss:Index="4" ss:StyleID="s24"<Data
ss:Type="String"Total</Data</Cell
<Cell ss:StyleID="s25"<Data
ss:Type="Number"1</Data</Cell
</Row
</Table
<WorksheetOptions xmlns="urn:schemas-microsoft-
com:office:excel"
<PageSetup
<Header x:Margin="0.4921259845"/
<Footer x:Margin="0.4921259845"/
<PageMargins x:Bottom="0.984251969"
x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/
</PageSetup
<Print
<ValidPrinterInfo/
<PaperSizeIndex9</PaperSizeIndex
<HorizontalResolution600</HorizontalResolution
<VerticalResolution600</VerticalResolution
</Print
<Selected/
<DisplayFormulas/
<Panes
<Pane
<Number3</Number
<ActiveRow5</ActiveRow
<ActiveCol4</ActiveCol
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
<PivotTable xmlns="urn:schemas-microsoft-
com:office:excel"
<Namept1</Name
<HideTotalsAnnotation/
<LocationR4C4:R7C5</Location
<DefaultVersion0</DefaultVersion
<PivotField
<Namea</Name
<DataTypeInteger</DataType
</PivotField
<PivotField
<Nameb</Name
<OrientationRow</Orientation
<Position1</Position
<DataTypeInteger</DataType
<PivotItem
<Name2</Name
</PivotItem
</PivotField
<PivotField
<DataField/
<NameDonnées</Name
<OrientationRow</Orientation
<Position-1</Position
</PivotField
<PivotField
<NameSomme a</Name
<ParentFielda</ParentField
<OrientationData</Orientation
<Position1</Position
</PivotField
<PTLineItems
<PTLineItem
<Item0</Item
</PTLineItem
<PTLineItem
<ItemTypeGrand</ItemType
<Item0</Item
</PTLineItem
</PTLineItems
<PTSource
<CacheIndex1</CacheIndex
<RefreshName </RefreshName
<RefreshDate2003-12-04T16:20:41</RefreshDate
<RefreshDateCopy2003-12-04T16:20:41</RefreshDateCopy
<ConsolidationReference
<FileNamea.xml</FileName
<Namea</Name
</ConsolidationReference
</PTSource
</PivotTable
</Worksheet
<Worksheet ss:Name="Feuil2"
<Table ss:ExpandedColumnCount="0"
ss:ExpandedRowCount="0" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60"/
<WorksheetOptions xmlns="urn:schemas-microsoft-
com:office:excel"
<PageSetup
<Header x:Margin="0.4921259845"/
<Footer x:Margin="0.4921259845"/
<PageMargins x:Bottom="0.984251969"
x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/
</PageSetup
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<Worksheet ss:Name="Feuil3"
<Table ss:ExpandedColumnCount="0"
ss:ExpandedRowCount="0" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60"/
<WorksheetOptions xmlns="urn:schemas-microsoft-
com:office:excel"
<PageSetup
<Header x:Margin="0.4921259845"/
<Footer x:Margin="0.4921259845"/
<PageMargins x:Bottom="0.984251969"
x:Left="0.78740157499999996"
x:Right="0.78740157499999996" x:Top="0.984251969"/
</PageSetup
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<PivotCache xmlns="urn:schemas-microsoft-
com:office:excel"
<CacheIndex1</CacheIndex
<Schema s:id="RowsetSchema" xmlns="uuid:BDC6E3F0-6DA3-
11d1-A2A3-00AA00C14882"
<ElementType s:name="row" s:content="eltOnly"
<attribute s:type="Col1"/
<attribute s:type="Col2"/
<extends s:type="rs:rowbase"/
</ElementType
<AttributeType s:name="Col1" rs:name="a"
<datatype dt:type="int"/
</AttributeType
<AttributeType s:name="Col2" rs:name="b"
<datatype dt:type="int"/
</AttributeType
</Schema
<data xmlns="urn:schemas-microsoft-com:rowset"
<row Col1="1" Col2="2" xmlns="#RowsetSchema"/
</data
</PivotCache
</Workbook

Reply With QuoteReply With Quote
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Threaded Mode Threaded Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error "invalid data source reference" for pivot table Manny Excel Worksheet Functions 6 April 5th 23 02:58 PM
Excel 2007: "Reference is not valid" when refreshing pivot table Paul Martin[_2_] Excel Discussion (Misc queries) 2 January 5th 10 02:47 AM
Pivot Table "Data source reference is not valid" error cause? Bill Neurohr Excel Discussion (Misc queries) 1 March 11th 09 10:16 PM
"Cannot open pivot table source file" scubadiver Excel Discussion (Misc queries) 0 October 10th 07 03:29 PM
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" Diana[_5_] Excel Programming 0 August 21st 03 10:19 PM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement