At 13:45 20/11/2007 -0800, Walter Hildebrandt wrote:
How do I copy a column of formulas into a second spreadsheet and have the results (the answers) of the formula appear in the second spreadsheet. When I do a regular Copy and Paste I get Error 522.
When you copy a formula into either another sheet of the same spreadsheet or a different spreadsheet (i.e. a separate file), the rows and column of the formula are adjusted (where appropriate) in the way they would be within a sheet, but no reference is made by default to the source sheet or spreadsheet. In other words, the values used in calculation of the formula will now be those from appropriate cells in your target sheet, not in the source sheet. If you see error 522 - circular reference - then your copied formulae must now be referencing themselves. This can easily happen if you have frozen some parts of the formulae with $ signs.
As so often, Paste Special is your friend. Instead of Paste, use Edit | Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V). One route is to choose Link, in which case the pasted cells become a copy of the original cells: they depend on the original formulae and the calculations they provide, in other words, not on a new copy of the same formulae. If you change the formulae in the source cells, the target results will change, too. This is as well as being dependent on the values in the cells which the formulae reference, of course.
To paste just the result of your formulae - as you appear to ask - use Paste Special, remove the tick from "Paste all", and then make sure that Numbers (or whatever) is ticked but Formulas is *not* ticked. This way, you get plain values in the target cells: once pasted, they no longer depend on the source sheet.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
