Copy and Link Issues 2010

M

Michael Dobony

I'm working in Excel 2010 and am having some copy issues. I have similar
workbooks, Commercial.XLSX and Residential.XLSX. Both have identical
worksheets Disc, Rates, Mode. When I copy a row of additions from
Commercial to Residential the formulas all include references to not only
the worksheets, but the original Commercial workbook. Is there a way to
copy without pulling the file names with the paste?

In addition, some of the formulas are now including drive:directory
information to linked files. I tried to delete the directory info, but they
remain and this is unacceptable. How can I get rid of the directory links?
 
I

isabelle

hi,

select menu> data> edit links

isabelle



Le 2012-12-14 08:42, Michael Dobony a écrit :
 

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

Top