I am creating a dashboard using an Excel doc as my master source. Because the dashboard data is all over my network, I have a master excel doc that has cell values that are links to cells in three other excel spreadsheets on my network. When I import the spreadsheet into Xcelsius, it says the links are wrong. I click the "Change Source" button and notice the links point to my hard drive (c:\agency\agency production\2008 production.xls) instead of the where the link should be (o:\agency\agency production\2008 production.xls). The master excel spreadsheet has all the links correctly going to our network drives.
I've tried recreating the master spreadsheet
breaking the links and recreating
Using FQDN names for the links instead of drive letters
I always get the same error.
Any help is appreciated.