| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i fix #REF error
after I cut&pasted a few cells on one page i got an #REF error on a linked
page. how do i correct this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i fix #REF error
Click the cell that displays the error, click the button that appears , and
then click Trace Error if it appears. You can find possible solutions there after. This basically happens when you paste cells over cells referred to by other formulas, or using a link to a program that is not running, linking to a dynamic data exchange or running a macro that enter a function that returns # REF! in case you do require those cells to be referred by other formulas you -- Thanks Suleman Peerzade "confused" wrote: after I cut&pasted a few cells on one page i got an #REF error on a linked page. how do i correct this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
