Close
Search
- Blogs
- Discussion
- SpreadsheetSetCellFormula NOT honored by Excel
HELP!!!! Upgraded CF to 2021 from 10.0. Up to date on CF patches (#3).
The following was working for YEARS until we updated CF. NO CODE WAS CHANGED FOR UPGRADE, WE ASSUMED CODE SHOULD REMAIN SAME.
- IN CF, open spreadsheet
- USE “SpreadsheetSetCellFormula” to set formula in given cell
- Write spreadsheet
- Open sheet in Excel. NO CF calculations are auto-calculated (Again, this was working perfectly for years). In Excel, we see the CF formula properly.
- ONLY solution is for user to control-alt-F9 to circumvent this.
HELP! We MUST have this function working properly as we rely on Excel/CF interface for company business.
Is this known bug?
LMK
HELP!!!! Upgraded CF to 2021 from 10.0. Up to date on CF patches (#3).
The following was working for YEARS until we updated CF. NO CODE WAS CHANGED FOR UPGRADE, WE ASSUMED CODE SHOULD REMAIN SAME.
- IN CF, open spreadsheet
- USE “SpreadsheetSetCellFormula” to set formula in given cell
- Write spreadsheet
- Open sheet in Excel. NO CF calculations are auto-calculated (Again, this was working perfectly for years). In Excel, we see the CF formula properly.
- ONLY solution is for user to control-alt-F9 to circumvent this.
HELP! We MUST have this function working properly as we rely on Excel/CF interface for company business.
Is this known bug?
LMK
All Comments
Sort by:
Most Recent
- Most Recent
- Most Relevant
© 2025 Adobe. All rights reserved.
Privacy | Terms of Use | Cookies | Contact Us | Do not sell or share my personal information






