Hi All,

Quick question - If I have a statistical calculations spreadsheet that is
linked to a seperate data sheet - does the data sheet have to be open in
order to use the EditLinksUpdate?

I want to try and link to a closed worksheet - is this possible without VBA?

Thanks

Andy

No, the file doesn't have to be open. In fact, if the file is open, the linked
formulas will be reevaluated with the next calculation.

When I'm building those formulas that contain links to other files, I like to
have both files open and use the mouse to point and click at the "sending"
cell. Then excel does the heavy work and builds the formula with the correct
syntax.

Andibevan wrote:

Hi All,

Quick question - If I have a statistical calculations spreadsheet that is
linked to a seperate data sheet - does the data sheet have to be open in
order to use the EditLinksUpdate?

I want to try and link to a closed worksheet - is this possible without VBA?

Thanks

Andy

--

Dave Peterson

I am linking to named ranges in a seperate workbook so that approach
unfortunately won't work.

I am finding that if I open the statistical sheet and then press update -
nothing happens and all the values say #value.

When I open up the data sheet the values all calculate.

From my understanding of your mail the behaviour of my sheet is not as you
describe.

Any ideas?

"Dave Peterson" wrote in message
...
No, the file doesn't have to be open. In fact, if the file is open, the
linked
formulas will be reevaluated with the next calculation.

When I'm building those formulas that contain links to other files, I like
to
have both files open and use the mouse to point and click at the "sending"
cell. Then excel does the heavy work and builds the formula with the
correct
syntax.

Andibevan wrote:

Hi All,

Quick question - If I have a statistical calculations spreadsheet that is
linked to a seperate data sheet - does the data sheet have to be open in
order to use the EditLinksUpdate?

I want to try and link to a closed worksheet - is this possible without
VBA?

Thanks

Andy

--

Dave Peterson

Simple links should update. But there are worksheet functions that won't work
with closed files.

=indirect(), =sumif(), =countif()

are a couple.

Do you use those in your formulas?

There might be alternative solutions.

Andibevan wrote:

I am linking to named ranges in a seperate workbook so that approach
unfortunately won't work.

I am finding that if I open the statistical sheet and then press update -
nothing happens and all the values say #value.

When I open up the data sheet the values all calculate.

From my understanding of your mail the behaviour of my sheet is not as you
describe.

Any ideas?

"Dave Peterson" wrote in message
...
No, the file doesn't have to be open. In fact, if the file is open, the
linked
formulas will be reevaluated with the next calculation.

When I'm building those formulas that contain links to other files, I like
to
have both files open and use the mouse to point and click at the "sending"
cell. Then excel does the heavy work and builds the formula with the
correct
syntax.

Andibevan wrote:

Hi All,

Quick question - If I have a statistical calculations spreadsheet that is
linked to a seperate data sheet - does the data sheet have to be open in
order to use the EditLinksUpdate?

I want to try and link to a closed worksheet - is this possible without
VBA?

Thanks

Andy

--

Dave Peterson

--

Dave Peterson

Dave,

Thanks for your comment - I am using sumproduct forumulas mainly - often
looking at 5 criteria. I have about 100 of these forumlas and if this is
included in the main workbook it slows it down immensley.

Ta

Andi

"Dave Peterson" wrote in message
...
Simple links should update. But there are worksheet functions that won't
work
with closed files.

=indirect(), =sumif(), =countif()

are a couple.

Do you use those in your formulas?

There might be alternative solutions.

Andibevan wrote:

I am linking to named ranges in a seperate workbook so that approach
unfortunately won't work.

I am finding that if I open the statistical sheet and then press update -
nothing happens and all the values say #value.

When I open up the data sheet the values all calculate.

From my understanding of your mail the behaviour of my sheet is not as you
describe.

Any ideas?

"Dave Peterson" wrote in message
...
No, the file doesn't have to be open. In fact, if the file is open, the
linked
formulas will be reevaluated with the next calculation.

When I'm building those formulas that contain links to other files, I like
to
have both files open and use the mouse to point and click at the "sending"
cell. Then excel does the heavy work and builds the formula with the
correct
syntax.

Andibevan wrote:

Hi All,

Quick question - If I have a statistical calculations spreadsheet that
is
linked to a seperate data sheet - does the data sheet have to be open in
order to use the EditLinksUpdate?

I want to try and link to a closed worksheet - is this possible without
VBA?

Thanks

Andy

--

Dave Peterson

--

Dave Peterson

I think it would depend on the ranges used within each =sumproduct() formula,
too.

The only way I know to speed things up is to open that other workbook.

Andibevan wrote:

Dave,

Thanks for your comment - I am using sumproduct forumulas mainly - often
looking at 5 criteria. I have about 100 of these forumlas and if this is
included in the main workbook it slows it down immensley.

Ta

Andi

"Dave Peterson" wrote in message
...
Simple links should update. But there are worksheet functions that won't
work
with closed files.

=indirect(), =sumif(), =countif()

are a couple.

Do you use those in your formulas?

There might be alternative solutions.

Andibevan wrote:

I am linking to named ranges in a seperate workbook so that approach
unfortunately won't work.

I am finding that if I open the statistical sheet and then press update -
nothing happens and all the values say #value.

When I open up the data sheet the values all calculate.

From my understanding of your mail the behaviour of my sheet is not as you
describe.

Any ideas?

"Dave Peterson" wrote in message
...
No, the file doesn't have to be open. In fact, if the file is open, the
linked
formulas will be reevaluated with the next calculation.

When I'm building those formulas that contain links to other files, I like
to
have both files open and use the mouse to point and click at the "sending"
cell. Then excel does the heavy work and builds the formula with the
correct
syntax.

Andibevan wrote:

Hi All,

Quick question - If I have a statistical calculations spreadsheet that
is
linked to a seperate data sheet - does the data sheet have to be open in
order to use the EditLinksUpdate?

I want to try and link to a closed worksheet - is this possible without
VBA?

Thanks

Andy

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson