#Name
 

I have a function in an addin i created which does some basic calculations
which is loaded and saved however when i open a spreadsheet that was saved
with calls to this function I get the #Name error

the addin is loaded when I open excel because if i add any more of these
functions into the spreadsheet it works, on loading the spreadsheet Excel
seems to process the sheet before loading the addins so fails

I works fine on some computers but not on others

#Name
 

Try Pressing 'F9' key after the spread sheet is opened.
This calculates the sheet again.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#Name
 

Thanks Sharad, but the problem is it's needs to retain the values without
having to re-calc the formula every time a user opens the sheet

"Sharad" wrote:

Try Pressing 'F9' key after the spread sheet is opened.
This calculates the sheet again.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#Name
 

Just a guess at a workaround.

Add an
application.calculate
line in the open event of that workbook to see if forcing a recalc helps.

Victor wrote:

I have a function in an addin i created which does some basic calculations
which is loaded and saved however when i open a spreadsheet that was saved
with calls to this function I get the #Name error

the addin is loaded when I open excel because if i add any more of these
functions into the spreadsheet it works, on loading the spreadsheet Excel
seems to process the sheet before loading the addins so fails

I works fine on some computers but not on others

--

Dave Peterson

#Name
 

Not sure if I am using this right. Can anyone help, I need a formula o
how to plug in goal(#) and a continuous % to goal running number

Thank

--
hungrecke
-----------------------------------------------------------------------
hungrecker's Profile: http://www.officehelp.in/member.php?userid=1
View this thread: http://www.officehelp.in/showthread.php?t=12805
Visit - http://www.officehelp.in/archive/index.php/ | http://www.officehelp.in/archive/index.php/f-86.html | http://www.officehelp.in/archive/index.php/f-115.html | http://www.officehelp.in/archive/index.php/f-122.htm