Clyde asked

QUOTE:
If XLC is used to develop a worksheet, will the formulas still exist when passed on to EXCEL users that do not have it installed?

The short answer is yes.

The longer answer is yes. All the XLC generated equations are enhanced windows metafiles (a native windows graphic) and will be stored within an excel document just like any other graphical object. If you want to send a document to a user without XLC installed the XLC functions OVD(), UND(), ODI(), UDI() & EQS() will generate a #NAME error. You can get round this by:

1) Send them to ExcelCalcs to pick up a free copy of XLC!

2) If you know that they do not have privileges to install software (maybe its a work machine) you can remove the functions using Excels 'Find and Replace'. The equation graphics will loose their parent EQS() definitions and the poor orphans will never be able to redrawn in response to a cell formula change - they will still hang around but they are just dumb graphics now.<br><br>Post edited by: JohnDoyle, at: 2007/03/17 11:13