the #REF! error appears in several worksheets that i have created it is in a cell that is a formula off from several other formula cells. when i open the worksheet (which happens to be a copy of another worksheet) some cells have that error, if i slect the cell, then click in the formula bar and press enter teh formula goes away, what may cause this and how do i fix it? thanks much
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
#ref! error
- Thread starter stibbetts
- Start date
SkipVought
Programmer
Hi,
Is Tools/Options - Calculation tab - set to AUTOMATIC or MANUAL?
Or does F9 change anything?
???
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Is Tools/Options - Calculation tab - set to AUTOMATIC or MANUAL?
Or does F9 change anything?
???
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #3
- Thread starter
- #4
- Thread starter
- #5
SkipVought
Programmer
Try Edit/Links and see if you can update the links
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #7
You will only have a links option if there are links within that specific workbook to other workbooks, not if other workbooks are linking to your one.
If you hit F2 and enter on all your cells and the errors go away, are you saving the workbook before you close it, and if so do they still return. If so, then what are the formulas in these cells, and what is in the cells they link to?
Regards
Ken...............
----------------------------------------------------------------------------
![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
It's easier to beg forgiveness than ask permission![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
----------------------------------------------------------------------------
If you hit F2 and enter on all your cells and the errors go away, are you saving the workbook before you close it, and if so do they still return. If so, then what are the formulas in these cells, and what is in the cells they link to?
Regards
Ken...............
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission----------------------------------------------------------------------------
- Thread starter
- #9
yes F2 then enter (or tab) will make the errors go away and they dont come back after its saved, the problem is that there is a master spreadsheetwith any number of lines, there is a custom app that sorts the spreadsheet and creates new spreadsheets (as many new spreadsheets as there are lines in the origional) with one line of info per each, that is because autodesk inventor only links to the first 3 lines of information in a sheet, the first is that variable name the second is the value and the third is the unit of measure (inventor is a drafting program). so there arent any other spreadsheets linked to this one, just the inventor program. hope tha tclears up the dilema a little more.
- Thread starter
- #10
heres something else i forgot to mention, i am referencing other cells in the sheet, i am not referencing them by cell however, i am referencing them by the variable above them ex.:
A B C
1 dima | dimb | dimc
2 34 | 21 | 46
2 in | in | in
so, instead of calling for A1 I am calling for dima, and it is returning 34 (in specifies inches, this is only for inventor), i have an if statement where a value is 0 and a value is "casw" when the value is 0 there si no error, when it is "casw" i get #REF! untill i do the F2 'enter' thing. strange part is it doesnt always need it, just usually and i cant find anything different when it doesnt.
A B C
1 dima | dimb | dimc
2 34 | 21 | 46
2 in | in | in
so, instead of calling for A1 I am calling for dima, and it is returning 34 (in specifies inches, this is only for inventor), i have an if statement where a value is 0 and a value is "casw" when the value is 0 there si no error, when it is "casw" i get #REF! untill i do the F2 'enter' thing. strange part is it doesnt always need it, just usually and i cant find anything different when it doesnt.
- Status
