Table of Contents

ExcelFile.ConvertExternalNamesToRefErrors Method

Overloads

ExcelFile.ConvertExternalNamesToRefErrors

Use it to convert the external names in a sheet to #REF! . It can be useful when you need to remove all external links in a file. NOTE: You will probably want to use ConvertFormulasToValues(Boolean) too.

Syntax

Namespace: FlexCel.Core

public void ConvertExternalNamesToRefErrors()

See also

ExcelFile.ConvertExternalNamesToRefErrors(Boolean)

Use it to convert the external names in a sheet to #REF! . It can be useful when you need to remove all external links in a file. NOTE: You will probably want to use ConvertFormulasToValues(Boolean) too.

Syntax

Namespace: FlexCel.Core

public abstract void ConvertExternalNamesToRefErrors(Boolean recalcBeforeConverting)

Parameters

<-> Parameter Type Description
recalcBeforeConverting Boolean If true (the default), FlexCel will try to recalculate the file before converting the formulas.
Use false when for any reason FlexCel can't recalculate the values (for example if you have links to other files that don't exist anymore)

See also