ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   #NAME? in cell when opening a Workbook (https://www.excelbanter.com/excel-programming/414618-name-cell-when-opening-workbook.html)

J. Caplan[_2_]

#NAME? in cell when opening a Workbook
 
I have some Excel VBA code that I saved as a .XLA Add-In file. I then have
this XLA set as an Add-In inside of Excel. If I enter my UDF into a cell, it
works correctly and returns the values that I expect.

Every time I re-open a Workbook that contains calls to my UDF in the Add-In,
all cells that call the UDF have " #NAME? " in the cell. Excel goes through
and recalculates these cells and all is correct and #NAME? is replaced with
the output of the UDF for the cell.

Why does Excel have to resolve the reference to this Add-In each time it
opens?


All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com