Linked data
 

I have successfully used the copy and past special method to link data
between 2 .xls documents When I edit the data in document 1, any
changes are reflected in document 2. However, when I replace document
1 with a copy of document 1 and then open document 2 I receive a
dialog box 'unable to read file'.

The cell locations in the new document 1 are identical to the
original, the only difference is the values. If I then open, save as
(document 1) and close the document. I can then open document 2 and
any changes will be reflected in document 2.

Any advice?

Linked data
 

What *exactly* do you mean when you say "replace"?

What procedure(s) do you follow?

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"paulmitchell507" wrote in message
...
I have successfully used the copy and past special method to link data
between 2 .xls documents When I edit the data in document 1, any
changes are reflected in document 2. However, when I replace document
1 with a copy of document 1 and then open document 2 I receive a
dialog box 'unable to read file'.

The cell locations in the new document 1 are identical to the
original, the only difference is the values. If I then open, save as
(document 1) and close the document. I can then open document 2 and
any changes will be reflected in document 2.

Any advice?

Linked data
 

On May 8, 4:47*pm, "RagDyeR" wrote:
What *exactly* do you mean when you say "replace"?

What procedure(s) do you follow?

--

Regards,

RD
---------------------------------------------------------------------------*--------------------
Please keep all correspondence within the Group, so all may benefit !
---------------------------------------------------------------------------*--------------------

"paulmitchell507" wrote in message

...
I have successfully used the copy and past special method to link data
between 2 .xls documents *When I edit the data in document 1, any
changes are reflected in document 2. *However, when I replace document
1 with a copy of document 1 *and then open document 2 I receive a
dialog box 'unable to read file'.

The cell locations in the new document 1 are identical to the
original, the only difference is the values. *If I then open, save as
(document 1) and close the document. *I can then open document 2 and
any changes will be reflected in document 2.

Any advice?

Ok, I have the 2 .xls documents (doc1 and doc2) stored on the
fileserver. I have an access database that is also located on the
fileserver. From an access macro I run a query that generates the
'replacement' .xls document. Using the 'OutputTo' action argument I
export the .xls spreadsheet to the same location on the fileserver as
doc2, thus overwriting the existing doc2.

This all works fine, the problem is that until I manually open
doc2.xls and select 'SaveAs' (keeping the name doc2.xls) doc1 will not
update any changes.

The short answer to your question RD is 'overwrite'

Regards,

Paul

Linked data
 

I don't know or use Access, but in a "standard" XL environment,
"overwriting" a WB with another WB, and then naming (renaming) it to the
name of the original *will* be recognized by XL, and will automatically
invoke the "Update Links" request, where a "Yes" answer will cause the
target WB links to be updated without any further action necessary with the
renamed source WB.

Perhaps Access does something to (with) the new name, that isn't recognized
by XL until it (XL) has a chance to "fix" it with a resave.

You might try posing this question to an Access group.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"paulmitchell507" wrote in message
...
On May 8, 4:47 pm, "RagDyeR" wrote:
What *exactly* do you mean when you say "replace"?

What procedure(s) do you follow?

--

Regards,

RD
---------------------------------------------------------------------------*--------------------
Please keep all correspondence within the Group, so all may benefit !
---------------------------------------------------------------------------*--------------------

"paulmitchell507" wrote in message

...
I have successfully used the copy and past special method to link data
between 2 .xls documents When I edit the data in document 1, any
changes are reflected in document 2. However, when I replace document
1 with a copy of document 1 and then open document 2 I receive a
dialog box 'unable to read file'.

The cell locations in the new document 1 are identical to the
original, the only difference is the values. If I then open, save as
(document 1) and close the document. I can then open document 2 and
any changes will be reflected in document 2.

Any advice?

Ok, I have the 2 .xls documents (doc1 and doc2) stored on the
fileserver. I have an access database that is also located on the
fileserver. From an access macro I run a query that generates the
'replacement' .xls document. Using the 'OutputTo' action argument I
export the .xls spreadsheet to the same location on the fileserver as
doc2, thus overwriting the existing doc2.

This all works fine, the problem is that until I manually open
doc2.xls and select 'SaveAs' (keeping the name doc2.xls) doc1 will not
update any changes.

The short answer to your question RD is 'overwrite'

Regards,

Paul