We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Update Sheet References


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?



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.