Custom excel function not updating


For help with specific questions, the Project Developer newsgroup is useful.

A workbook of mine that worked fine for several years, when using Excel 2003, suddenly refused to update all the formulas, after a switch to Excel 2010. When someone tells you that formulas aren't calculating, it's probably because the Calculation setting has been changed to Manual, instead of Automatic.

For general examples and more information about formulas and expressions, see Guide to Expression Syntax in the online help for Access and To create or edit a formula for a local custom field or outline code, you must use Project Professional 2010 or Project Standard 2010.

You can add fields from Project Professional that the The following procedure is required only if you use one of the older PSI methods to create or modify custom fields.Table 1 includes resource fields that show only in Project Professional 2010.A formula-based resource custom field that is defined in Project Web App can reference these fields.This is not a big problem -- until you attempt to copy the formula across other worksheets.The copied formulas continue to refer to the original worksheet name.Category: VBA Functions | [Item URL] You may have discovered that Excel's support for "3D workbooks" is limited.

You must have an account to comment. Please register or login here!