logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
vonanka  
#1 Posted : Saturday, August 8, 2015 2:43:36 PM(UTC)
vonanka

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

 

mstt  
#2 Posted : Sunday, August 9, 2015 7:39:39 AM(UTC)
mstt

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
Guest  
#3 Posted : Sunday, August 9, 2015 10:27:29 AM(UTC)
Guest

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
vonanka  
#4 Posted : Sunday, August 9, 2015 10:30:39 AM(UTC)
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 
mstt  
#5 Posted : Sunday, August 9, 2015 11:45:39 AM(UTC)
mstt

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
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.