Problem with Linked Files
 

Hi,

I have two files. One contains pricing data and the other is a quotation
generator (template file). The price file is accessed over the network.
This procedure works perfectly on the machine that the template was developed
on, but as soon as I copy the template to another machine, the quotation
template is failing to update links from the price file.

When opening the template, I get the question re updating links (which I
don't want) and when I select to update it errors. After this I do Edit,
Links and the source file shows Status OK.

Any assistance would be appreciated.

Problem with Linked Files
 

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Steve wrote:

Hi,

I have two files. One contains pricing data and the other is a quotation
generator (template file). The price file is accessed over the network.
This procedure works perfectly on the machine that the template was developed
on, but as soon as I copy the template to another machine, the quotation
template is failing to update links from the price file.

When opening the template, I get the question re updating links (which I
don't want) and when I select to update it errors. After this I do Edit,
Links and the source file shows Status OK.

Any assistance would be appreciated.

--

Dave Peterson

Problem with Linked Files
 

Running Office 2003 on all machines. All files generated using Excel 2003.

Can I insert a macro at file open to control the updating of links manually
and overcome the error?

"Dave Peterson" wrote:

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Steve wrote:

Hi,

I have two files. One contains pricing data and the other is a quotation
generator (template file). The price file is accessed over the network.
This procedure works perfectly on the machine that the template was developed
on, but as soon as I copy the template to another machine, the quotation
template is failing to update links from the price file.

When opening the template, I get the question re updating links (which I
don't want) and when I select to update it errors. After this I do Edit,
Links and the source file shows Status OK.

Any assistance would be appreciated.

--

Dave Peterson

Problem with Linked Files
 

Are you sure that the links point to the correct location--maybe it uses a
different mapped drive?

And refreshing the values doesn't help?

Steve wrote:

Running Office 2003 on all machines. All files generated using Excel 2003.

Can I insert a macro at file open to control the updating of links manually
and overcome the error?

"Dave Peterson" wrote:

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Steve wrote:

Hi,

I have two files. One contains pricing data and the other is a quotation
generator (template file). The price file is accessed over the network.
This procedure works perfectly on the machine that the template was developed
on, but as soon as I copy the template to another machine, the quotation
template is failing to update links from the price file.

When opening the template, I get the question re updating links (which I
don't want) and when I select to update it errors. After this I do Edit,
Links and the source file shows Status OK.

Any assistance would be appreciated.

--

Dave Peterson


--

Dave Peterson