Do not change Excel sheet names in Xcelsius design mode

excelsheetnamesIf you are an Excel user, you tend to change the Excel Sheet Names when your are done with your work in Excel. You need to get rid of this practice when it comes to Xcelsius 2008. Make sure that you decide on your sheet names before you import the model into Xcelsius, because if you change the sheet names after you have imported and mapped your components, Xcelsius might throw an error at you. I say just error, because it does not display anything on the error dialog box. As a best practice make sure that you have named your sheets in excel before importing the model into Xcelsius. Just in case you have not done that and want to do it after designing your dashboard then follow the below steps:

  1. Export the excel file
  2. Open it in Excel
  3. Change the sheet names
  4. Re-import it back to Xcelsius.
  5. Be prepared to re-map your components.

Hope this helps!

  • Agasti

    Hello Kalyan,
    There must be some reason for this error. But I am sure this error is not always when you Rename the xcel file. I have done this couple of times and found that with renaming the spreadsheet in designing mode will re-map components automatically according to changed name.
    I didn’t get any error till now.. lucky me? 🙂