Skip to Content
0
Former Member
Jul 15, 2008 at 12:01 AM

Can' connect categories from different excel spreadsheets of an excel book.

31 Views

Hi,

I need a bit of help. My excel book has 10 spreadsheets and I've started to create the dynamic presentation. As long I'm introducing data (labels, input text, etc) from the first spreadsheet (or from the 9 and 10), I can see the values on the presentation. When I'm creating the links from other cells from the rest of the spreadsheets (without 1,9,10), there are no values to be seen on the properties of the categories or in the presentation (even though, on the excel file, the values exists). It's like there is nothing writen on the cells which is not true.

Any idea?

(The only diferent on the excel is that when I'm inserting data from spreadsheet 1,9,10 then I can see the heading of the spreadsheet from which the data comes in the following format " Name!$A$2 ", while from the rest of the spreadsheets is " 'Name'!$B$5 ".

Thank you for your help.

Adrian