EPMSaveData default value to populate database

[jim_juliano]

I am using the EPMSaveData function to store/refresh a cell "Growth Rate %." However, I would like the template do display a default value (2.5%) in this cell prior to the user's first save. Currently the function would return "0" as nothing has been populated in the database. We would like to save and refresh last input value, whether default or the user's input rate going forward.

We have considered doing a mass population of these fields,but I believe there should be a better way.

I have been playing with nesting the function and considering VBA solutions (on open or on change events), but have not yet resolved.

Any suggestions?  Thanks

[jim_juliano · Accepted solution]

I resolved this issue by doing an evaluation of the cell values After_Refresh