How to consolidate Data from two different Workbook ?

other Xcelsius - Crystal Dashboard Design
1

Hi Xcelcius User …

I have a situation in which I have to take data from two different work book (Work book 1 ,2) and consolidate into one .

Can you please let me know the different ways to achieve this .

Is it possible that data in workbook 1 gets updated the consolidated one gets updated automatically .

Right now in both the sheet the data is captured manully.

Regards
Swapnil

swapnil_taz :india: (BOB member since 2006-04-06)

2

You can only use one Excel workbook (file) as a data source in Xcelsius. Why do you need to have 2 separate files? Since the data is static as you say then you have to either combine the two workbooks before importing the Excel file into Xcelsius.

J0sh :australia: (BOB member since 2006-10-09)

3

You cannot use two different Excel doc for the same document.

Combine the data from two different excel workbook into one and Export the sheet from Data -> Export

Let me know if you need further help.

neel22 (BOB member since 2009-05-15)