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?
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?