The situation is this:

*All the computers have Windows XP.
*All this is working under a net.
*In computer A: I have a bloomberg terminal.
*In computer A: I have an excel sheet open linked to bloomberg that
automatically updates the information.
*In computer B: I have an excel sheet and I want that everything
updates in this computer too.

Any help?

Thanks.

Hi,

You could link both workbooks to bloomberg, or link the workbook on computer
B to the workbook on computer A.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The situation is this:

*All the computers have Windows XP.
*All this is working under a net.
*In computer A: I have a bloomberg terminal.
*In computer A: I have an excel sheet open linked to bloomberg that
automatically updates the information.
*In computer B: I have an excel sheet and I want that everything
updates in this computer too.

Any help?

Thanks.

The problem is that Bloomberg only allows updates in the same computer.
So my idea is to link the excel sheets, right now I can not link the
excel sheet in computer B to A with a refresh.

Any idea?

Thanks.



macropod ha escrito:

Hi,

You could link both workbooks to bloomberg, or link the workbook on computer
B to the workbook on computer A.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The situation is this:

*All the computers have Windows XP.
*All this is working under a net.
*In computer A: I have a bloomberg terminal.
*In computer A: I have an excel sheet open linked to bloomberg that
automatically updates the information.
*In computer B: I have an excel sheet and I want that everything
updates in this computer too.

Any help?

Thanks.

Hi,

You'll need to provide more information on how you're trying to link the two
workbooks, and what's not working.

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The problem is that Bloomberg only allows updates in the same computer.
So my idea is to link the excel sheets, right now I can not link the
excel sheet in computer B to A with a refresh.

Any idea?

Thanks.



macropod ha escrito:

Hi,

You could link both workbooks to bloomberg, or link the workbook on
computer
B to the workbook on computer A.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The situation is this:

*All the computers have Windows XP.
*All this is working under a net.
*In computer A: I have a bloomberg terminal.
*In computer A: I have an excel sheet open linked to bloomberg that
automatically updates the information.
*In computer B: I have an excel sheet and I want that everything
updates in this computer too.

Any help?

Thanks.

Ok here we go:

I have in bloomberg an excel sheet running with live prices.

I create other excel sheet in my computer linked to this file.

When I run for the first time in my computer the prices refresh only
one time, but I need to find a way to make my excel sheet to go to the
bloomberg excel sheet and update the prices. Something like a refresh.

Is this more clear?

Thanks for all your help.


macropod ha escrito:

Hi,

You'll need to provide more information on how you're trying to link the two
workbooks, and what's not working.

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The problem is that Bloomberg only allows updates in the same computer.
So my idea is to link the excel sheets, right now I can not link the
excel sheet in computer B to A with a refresh.

Any idea?

Thanks.



macropod ha escrito:

Hi,

You could link both workbooks to bloomberg, or link the workbook on
computer
B to the workbook on computer A.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The situation is this:

*All the computers have Windows XP.
*All this is working under a net.
*In computer A: I have a bloomberg terminal.
*In computer A: I have an excel sheet open linked to bloomberg that
automatically updates the information.
*In computer B: I have an excel sheet and I want that everything
updates in this computer too.

Any help?

Thanks.

Hi,

You could probably use a timer driven macro to the 'B' workbook to refresh
the links periodically, but you might have to add a similar one to the 'A'
workbook to make it save periodically also - I'm not sure whether the link
would pick up unsaved data in this situation. Experiment and see.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
Ok here we go:

I have in bloomberg an excel sheet running with live prices.

I create other excel sheet in my computer linked to this file.

When I run for the first time in my computer the prices refresh only
one time, but I need to find a way to make my excel sheet to go to the
bloomberg excel sheet and update the prices. Something like a refresh.

Is this more clear?

Thanks for all your help.


macropod ha escrito:

Hi,

You'll need to provide more information on how you're trying to link the
two
workbooks, and what's not working.

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The problem is that Bloomberg only allows updates in the same
computer.
So my idea is to link the excel sheets, right now I can not link the
excel sheet in computer B to A with a refresh.

Any idea?

Thanks.



macropod ha escrito:

Hi,

You could link both workbooks to bloomberg, or link the workbook on
computer
B to the workbook on computer A.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
The situation is this:

*All the computers have Windows XP.
*All this is working under a net.
*In computer A: I have a bloomberg terminal.
*In computer A: I have an excel sheet open linked to bloomberg
that
automatically updates the information.
*In computer B: I have an excel sheet and I want that everything
updates in this computer too.

Any help?

Thanks.