- #1
- 7,320
- 11,152
- TL;DR Summary
- Trying to fix #HREF! problems that come about when pasting formular-based columns in Excel 2007.
Hi all,
I am having #HREF! issues in Excel 2007 when copying formula-based data from one sheet to another. The suggested solutions online are not working.
I understand what the issue is: when copying from one sheet to another, Excel is trying to use data from the previous sheet, sheet_j, say, , which is not available to it, to obtain data for sheet_k. In this case, in sheet_j, the entries are averages of values in columns in sheet_j. When pasting, Excel apparently has no access to these values, so the formula, say, Average(A1:A5) makes no sense without knowing what A1:A5 are.
Still, the suggested solutions I found online are not working.Any other ideas?
I am having #HREF! issues in Excel 2007 when copying formula-based data from one sheet to another. The suggested solutions online are not working.
I understand what the issue is: when copying from one sheet to another, Excel is trying to use data from the previous sheet, sheet_j, say, , which is not available to it, to obtain data for sheet_k. In this case, in sheet_j, the entries are averages of values in columns in sheet_j. When pasting, Excel apparently has no access to these values, so the formula, say, Average(A1:A5) makes no sense without knowing what A1:A5 are.
Still, the suggested solutions I found online are not working.Any other ideas?