Links Don't follow with copy

  • Thread starter Thread starter swrobles
  • Start date Start date
S

swrobles

Hi,


I have a group of worksheets that have cells linked among them. In the
past
when I would copy this group of sheets to a different directory all of
the
links would update to reflect their new location. Example: A link that
was
=C:\data\sample'!$B$10 would change to
=C:\backup\data\'sampl'!$B$10.

Now when I copy the group of sheets to the
backup folder the links don't reflect the move as they did in the past.


Any thoughts on this?


Thank you,
 
Hi,

it sounds a litle strange, excel will update the new links if you save as
the source file in a new directory, but, the destiny WS also needs to open.

copying one ws using the explorer for eg. do not change the links

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"(e-mail address removed)" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking w/Paste Special 1
Excel Move or Copy Stopped Working? 0
Links 4
Copying linked sheet 2
How to create absolue path link to another workbook (Excel 2003) 1
broken links 6
Links 1
Custom Sorting a linked work sheet 2

Back
Top