Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|