Do I need to install Macromedia Flash to run Crystal Xcelsius™?
The Macromedia Flash player is required for Crystal Xcelsius™ to function properly. If you skipped this part of the install process, you can download and install Flash yourself from the Macromedia website here.
What Excel functions are supported by Crystal Xcelsius™?
See the Excel Functions section in the Reference for a complete list of functions.
Can I re-import an Excel file with a renamed sheet?
See the Re-importing with Renamed Sheets section of Re-Importing the Excel File Users Guide for issues with renamed sheets.
What is the maximum limit of rows for a single spreadsheet selection?
There is no limit to the number of rows for a selection. However, the size of your selection can affect the performance of your model. Crystal Xcelsius™ will warn you if you select more than 512 rows.
Does Crystal Xcelsius™ support Excel files which link to other Excel files?
No, this feature is not supported by Crystal Xcelsius™.
Why don’t my Excel macros work?
Crystal Xcelsius™ does not support macros in Excel spreadsheets at this time.
Why doesn't my component show scientific formatting?
The visual display of scientific formatted numbers is not supported at this time. Calculations that are dependent upon scientific formatted numbers are not affected.
How large can my Excel file be?
There is no limit to the size of an Excel spreadsheet that can be used in Crystal Xcelsius™. There are a number of factors, however, which may affect the performance of your model. These include the number of components you have on the stage, the amount of data that is being changed during the simulation, the complexity of the calculations being performed, and so forth. The speed of the computer can also greatly affect performance, and should be kept in mind when developing models that will be distributed to other users.
Which regional Excel formats does Crystal Xcelsius™ support?
Crystal Xcelsius™ automatically detects the regional formatting being used
on your machine and adjusts its output appropriately. For example, if your
regional settings use the "/" for the date separator, the date January 2nd,
2004 would appear as "1/2/04" in your Crystal Xcelsius™ models. If your regional
settings use the "-" for the date separator, the date would appear as "1-2-04"
in the exported model. These settings can be found under the Regional and
Language Options of the Windows Control Panel. The following items are
- decimal separator
- thousands separator
- general format name
- time separator
- date separator
Why doesn't Crystal Xcelsius™ work after I upgrade/install Microsoft Office?
When Crystal Xcelsius™ is installed, it automatically configures itself to work with the version of Microsoft Office that is installed. If you upgrade or change the version of Microsoft Office on your machine, Crystal Xcelsius™ must be re-installed to work properly with the new version.
Why does my Table look different than my Excel spreadsheet?
Your Excel spreadsheets may be using a different font than the currently selected font which will result in minor visual differences between the spreadsheet and your tables. In order to match your views, change the spreadsheet font to match your currently selected font, or change your font in Crystal Xcelsius™ to match the font that is in the imported Excel file.
Why doesn’t my URL button work?
Your URL needs to include http:// in order for it to function correctly.
What happened to the scenarios I saved?
If you are having trouble with saving and loading scenarios with the Scenario button, please refer to the Users Guide on Using the Scenario Component.
Why can't I drag my Slider, Dial, etc.?
The values of single value components that are linked to cells with formulas can not be adjusted in order to prevent inconsistencies in the model.
How do I change my Alert Target and Font colors?
The color bar controls which color is currently active for editing. You can then use the appropriate color buttons to edit the individual colors. Please refer to Introduction to Alerts for more information.
Why aren't my Use Web Service models refreshing when running in Internet Explorer?
Internet Explorer has default cache settings that prevent Crystal Xcelsius™ models from refreshing properly. Please refer to Internet Explorer Caching Issues for more information.
What happened to my cell formatting when I Replaced Data Selection?
Replace Data Selection does not change the cell format. For more information, please see the Users Guide section on Updating Data for a Model.
How can I embed a Crystal Xcelsius™ model into an existing PowerPoint presentation?
Within Crystal Xcelsius™ you can embed your current model into a new PowerPoint presentation with only a few clicks using the Export to PowerPoint options. To embed the model into an existing PowerPoint presentation, simply export like above, copy the model from the new PowerPoint presentation, and paste it into your existing presentation. If your model contains any external files which aren't embedded into the model, you will also need to copy the folder containing those files into the same directory as your PowerPoint presentation. When the model is exported, this folder is created with the same name and location as the exported model.
Why won't my model print correctly?
Printing your model through the Menu of the Flash Player doesn't work since the Flash Player does not print transparent objects properly. Printing through the browser may also print the model with incorrect proportions. To correctly print your model, first take a screen shot using Ctrl+PrintScreen (entire screen) or Alt+PrintScreen (focused window only). Paste the screen shot into an image program and print through that program's options.
Why do I get a “Server Busy” message?
This means that Excel has a pending operation or is busy performing an instruction. Check Excel to make sure it is not in the process of editing and then click Retry on the warning dialog.
Why do I get the message "A script in this movie is causing Flash Player to run slowly..."?
The Macromedia Flash Player which is used to view Crystal Xcelsius™ models
will show this message whenever a script has taken more than 60 seconds. Due
to the complexity of Crystal Xcelsius™ models, larger models running on slow machines
may cause this message to be shown, particularly at startup. By continuing to
press "No", the model should load properly.
Note: While in Preview Mode, pressing "Yes" to abort the script will cause Preview to stop working. You will need to switch to Canvas Mode, then back to Preview Mode, to properly preview the model.
Why does my model start in a strange state?
When a model is loaded, all selectors will insert their default selection data into their Insert In ranges to populate other components with data. When more than one selector inserts into the same range, the selector at the highest level will insert last, overriding the default data inserted by the other selectors. You can use the Object Browser to view the order of the components and change the order using the Layer Options.
Why aren't my data sources refreshing?
Certain data sources are denoted as static with a green Excel icon. These data sources do not refresh during the course of the model. Please refer to the Dynamic vs. Static Data Sources section of the User Guide.
Why aren't my formula based indexes for my VLOOKUP array changing at runtime?
In order to maintain the speed and efficiency of the VLOOKUP function, Crystal Xcelsius™ doesn't recalculate formulas in the index column of a VLOOKUP array. If you have a VLOOKUP function that contains a formula in the index column, the index column cell will always contain the initial value of the formula.
Why can't I see my URL based images in preview mode?
Are your URL's relative paths? URL references to images that are relative paths won't display in preview mode because the preview SWF file is generated in a temporary directory. If you export your SWF file to a location that will make the relative paths valid, your images should load properly.
Are you referencing jpeg files that are hosted on a web site? If you are referencing jpeg files on a web site, be sure that the jpeg files are not "progressive" jpegs. Progressive jpegs load in stages. This allows low-bandwidth users to see an image quickly, without having to wait for the entire image to load. Crystal Xcelsius™ cannot display progressive jpegs that are referenced via a URL. However, if you select the embed option, Crystal Xcelsius™ will display progressive jpegs properly.
Why am I getting a "Truncation Occurred..." dialog when I try to preview my model?
Crystal Xcelsius™ has a default value for the maximum number of rows that can be referenced in either a formula or source data for a component. If you are getting the "Truncation Occurred..." dialog when you click preview, your model contains a function that has a reference to an array of cells that exceeds the maximum number of rows setting. You can change this setting through the Data->Maximum Rows... menu item. The maximum rows setting exists to help ensure optimal performance of Crystal Xcelsius™ models.
Why aren't my International settings used?
An XLF will continue to use the International settings of the machine it was created with until the spreadsheet is re-imported into the model. These settings include items such as the Decimal and Thousands separator characters.