Excel Add-In: Inserting custom columns & calculating Excel formulas

  • 5 October 2023
  • 0 replies

Userlevel 2

If you encounter issues while incorporating Excel formulas (in custom columns) into worksheets containing data retrieved using the CData Excel Add-In, follow these steps for seamless integration: 

  1. Ensure that you add the custom column at a minimum of one column's separation from the CData table. 




  1. Within this custom column, execute any desired formula to enhance data processing and analysis. 




  1. Notably, the custom column persists even after refreshing the worksheet, preserving the formula and its functionality. 




Enhancing your Excel experience with the CData Excel Add-In, these steps allow you to effortlessly incorporate custom calculations and maintain their integrity even after data refreshes. 


If this solution does not resolve the problem, please do not hesitate to contact support at support@cdata.com

This topic has been closed for comments