Bloomberg Links Update

[Cellardoor]

Dear all good morning.

I have a file with Bloomberg Links (and if i want to update them, i need to open this file in another computer, different from my personal one).

The thing is that i need some code to simply don't update these links when i open the file. I tried everything. Private Sub Open, Update links = False etc...

I want this because when i open the file in my pc, the links can't be updated (due to the lack of connection with bloomberg terminal) and i receive #NA/ NA values (and i can't use this for calculations)

Can someone help me, please?

Thank you all

Cellardoor

 

[Deepak]

File??????????

 

[Cellardoor]

Dear Deepak thank you for the reply.

Honestly i've managed another solution. It's not the best but, for now, it's fine.

Working with bloomberg can be an headache :s

Thank you