Update Sheet References

[bernd.podhradsky]

Hi!

Is there a way to quickly update all references within a sheet to another sheet?

Example: we have Sheet1, Sheet2 and Sheet3. Sheet2 contains formulas, pivot tables etc., all referencing Sheet1. We now want all these references to point to Sheet3 instead. Is there a quick way to do this or do we actually have to analyze every reference manually?

BR,
Bernd

[Amjad_Sahi]

@bernd.podhradsky,

No there is no automatic way or API to update reference of the formulas in Aspose.Cells. Even I could not find any option available (to do that task) in MS Excel either. So, you have to update each formula reference manually via code.