Skip to Content
Former Member
Jun 04, 2009 at 02:25 PM

Xcelsius 2008 - Gauge>General>Data - Cannot Change Target Cell in Excel


Hi there, I hope someone can help me with this issue as I am bamboozled by it!

Firstly, I am using XML Maps in Excel to get data out of my database. Once I had got my spreadsheet to display all of the relevant data, I imported it into Xcelsius. I added 12 Gauges to my Canvas in Xcelsius then for each Gauge, I went onto properties 'General' > 'Data' and selected an appropriate cell in the spreadsheet, so my Gauge would display some data. When I created the SWF file, everything worked fine and dandy.

I have now edited the spreadsheet so it includes new fields that I didn't originally think I would need. I imported this spreadsheet into Xcelsius once more and the Gauges are showing incorrect values, which is understandable as the Gauges are now pointing to wrong cells within the Excel spreadsheet.

Here is the problem: This time when I go to the Gauge's properties and select 'General' > 'Data' and choose the appropriate cell, the properties do not update. In fact, the 'Data' textbox simply retains the old value. For example:

Old Value = Pivot!$J$466

Desired New Value = Pivot!$J$506

The Value Xcelsius displays and won't change: Pivot!$J$466.

Your help will be very much appreciated.