I am wondering if I can use defined names from excel in a performance equation. I have been searching the boards but have not found anything that references this. I have several integer values that I use in performance equations in a spreadsheet and I was thinking it may be easier to maintain these if I had them as a defined name, using the name manager in excel or if I could do a cell reference. I did see the syntax for a cell reference but I could not get that to work, I am using calculated data in the datalink. The thing that may complicate that is the references are on another page of the work book, my syntax looked like this '"&'Behind the Scenes'!F58&"' or '"&Ref_Temp&'"
The entire equation looks like this: (('FIC-311.PVI'*1000)*(172+(('TIC-448.PVI'*0.4363)-(0.5332*'TI-313.PVI')))/1000000)+(('FIC-327.PVI'*(172+(0.4363*'TIC-448.PVI')-('TI-330.PVI'*0.5332)))/1000000) I was hoping to use the defined name or the cell reference to replace the number values.
Thank you for the help.