Posted 1 July 2024, 12:01 pm EST
Is there a property for C1.Excel workbook that is the equivalent of the Excel workbook property UpdateRemoteReferences?
C1.Excel property for UpdateRemoteReferences
Posted by: twhighnine on 1 July 2024, 12:01 pm EST
-
twhighnine
-
uttkarsh.matiyal
Posted 2 July 2024, 7:52 am EST
Hello,
We have escalated your requirement to the development team. Rest assured, we’ll update you once we get any necessary information.
[Internal Tracking ID: C1WIN-32596]Regards,
Uttkarsh. -
uttkarsh.matiyal
Posted 3 July 2024, 7:32 am EST
Hello,
As per the developers, VBA is not currently supported in C1.Excel, so there is no UpdateRemoteReferences property or any equivalent in this library.
Could you please describe exactly why you need this property and provide details about your use case so that we can assist you accordingly?
Regards,
Uttkarsh. -
twhighnine
Posted 7 July 2024, 11:28 am EST
a separate workbook(A) is being created that is referenced by another workbook(B). when using the Office Excel Object library, using this command eliminated any excel prompts for broken links, etc. when opening B. The purpose was to remove the prompts for users. using C1.Excel, the workaround is to open A with Excel and save or have the user click one of the Excel prompts when showing the broken links after opening B.
We had the same issue creating A with the Excel Object Library until we set property to True. We were using the method for many years. We will now review what options may be available in Excel if the VBA property is not available after switching to using C1.Excel.
thanks, we can close this.
-
uttkarsh.matiyal
Posted 8 July 2024, 8:02 am EST
Hello,
Apologies for the inconvenience.
We have forwarded your use case to the developer to get their insights. Rest assured, we’ll update you if there is a viable solution/workaround for this requirement.Regards,
Uttkarsh.
