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

Portability of spreadsheets to users without XLC will sometimes be an issue. I have (and will) recommended that people should install XLC and try it out (I don't think many of them will go back to not using it!), but this is not always an option. (E.g. company IT procedures may not allow downloading and installing "unapproved" software). The following Macro will remove all OVD, UND, and EQS functions, leaving a clean (but "dumb" spreadsheet which can safely be circulated to those poor unfortunates who are not able to download this great utility.

Sub Un_XLC()
'
' Un_XLC Macro
' Deletes all references to "OVD", "UND" and "EQS"
'
Cells.Replace What:="ovd", Replacement:="", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Cells.Replace What:="und", Replacement:="", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Cells.Replace What:="=eqs(*)", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

Thanks for the macro.
Will use it if needed.
Anyway this is not an issue with me.
I haven't been required to send my calculations in .xls format.
I send it in pdf format or printed copies on paper.
Regards
G Vishwanath
Bangalore, India

A new button called 'Delete XLC functions' has been included in XLC version 05.07. This button must be used with caution because it deletes all functions "OVD", "UND", "ODI", "UDI" and "EQS". If one or more of these functions does not exist on the sheet Excel will prompt you to say that it could not find the data it was searching for.
Your worksheet will look the same but with XLC functions removed your equation objects become static graphic and cannot be updated. Your worksheet is now a native Excel file and can be sent to a user without XLC (some unfortunate people cannot install XLC on their machines at work).
It is strongly recommended that you always save an XLC version of any file that you create without XLC function! Be aware there is no undo on XLC!