Software

Ask something
Discussion Locked

How to paste without link in Excel

0 helpful
5 replies

by thosjaquet

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Software: Excel 2003

Problem: Excel automatically adds a link to formulas during a copy/paste operation between workbooks.

Goal: I want to copy formulas from Workbook 1 to Workbook 2 without links to Workbook 1. In other words, I want to duplicate the formulas in a range of cells that I wrote in one workbook in a range of cells in another existing workbook. I have tried all of Excel's paste options to no avail. The link to the original workbook is always added to the formulas.

Question:Is there a way to accomplish this simple task with Excel or is there a macro that I can write/download?

5 replies

by robo_dev

Maybe I don't understand your question exactly...I use Excel 2003 every day and it pastes formulas directly between workbooks. Do your formulas have anything special such as absolute references or arrays????

by goose82100

When you copy the formula, copy it from the formula bar at the top of the excel window, this way you get the text of the formula and not the text of it's results. Then when you paste into Excel windows 2 you paste the forula and not it's results from Excel window 1!

by clequesne

I found a work around for the same issue you have had, paste the formulas as usual. You will have the other spreadsheets ref appended to the resulting formulas which is not what you want.

The solution is to do a find and replace for the external part of the formulas, and replace it with nothing. You then end up with formulas "looking" at the new spreadsheet, not where you copied the original formula from.

This discussion is closed to new replies.