Discussions
»
Special Interest Groups
»
Basic Coding Techniques
»
Copy value to work around circular referenceproblem
Rank: Newbie
Groups: Registered Users, Subscribers Joined: 7/31/2015(UTC) Posts: 2
|
I have problem with circular reference to my formulas, Is there a way to set values and then call for them without any link to the formula that have created them? Just like Excels copy and then paste dead values and not the formula ?
I have tried the GV.dll but it seems to reference back to the original formula, thus creating circular reference problem.
Many thanks !
Kind regards
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 7/25/2005(UTC) Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi vonanka
I would need to see your code (both with and without a GV DLL) in order to come up with any possible ways to get around the problem. PREV can often provide a solution but that always slows execution speed, often to an unacceptable level. If you don't want to post your code then send me a Private Message or an email.
Roy
|
|
|
|
Rank: Member
Groups: Guests
Joined: 5/6/2007(UTC) Posts: 25
|
Hi Roy, I can not send the code.
But is it possible to write a dll that does a hard copy of the numbers so I can use them without getting the circular references?
Thanking you for the time !
VonAnka
|
|
|
|
Rank: Newbie
Groups: Registered Users, Subscribers Joined: 7/31/2015(UTC) Posts: 2
|
Hi Roy, I can not send the code.
But is it possible to write a dll that does a hard copy of the numbers so I can use them without getting the circular references?
Thanking you for the time !
VonAnka
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 7/25/2005(UTC) Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi vonanka
I do not have the skills to create a DLL of any sort, and without seeing the problem code I have no way of helping you come up with a solution to the circular reference issue. I didn't create the GV DLL but I probably know as much as anybody about it's strengths and weaknesses. But again, without code there's nothing I can do to help.
Roy
|
|
|
|
Users browsing this topic |
|
Discussions
»
Special Interest Groups
»
Basic Coding Techniques
»
Copy value to work around circular referenceproblem
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.