Processing
 

Can a PowerPivot pivot table in one workbook with data in a different workbook be refreshed without having the data workbook open?

02/09/2016 14:29#1

ChrisG

Member

Joined at: 7 months ago

Post: 2

Thank: 0

Thanked: 0

To start off, I'm working with PowerPivot in Excel 2013.

I have two workbooks: The first workbook has some facts and dimensions tables. I used those tables to create a data model with PowerPivot. I add data to the facts tables on a daily basis. The second workbook has a pivot table created from the first workbook's data model. Myself and others will want to build reports using the pivot table that's connected to workbook 1.

Both of these workbooks live on a shared network drive.

My question, is it possible for a user to refresh the data in workbook 2 without having workbook 1 open? It failed for me when I tried it.

The error message is "We couldn't get the data from 'obscured[#Data]' in the workbook 'obscuredpath\obscuredfile.xlsx' Open this workbook in Excel and try again"

Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

4 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re