Solved

# Excel 2007

Posted on 2014-03-26
308 Views
My OS is windows 7 prof 64 bit and I received an Excel file which I opened in Excel 2007 and it opened without a problem.  But in many cells I see things like #Ref!, and the contents of that cell is as follows giving an example :
=((((((((((G5+I5)+K5)+M5)+O5)+Q5)+S5)+U5)+W5)+Y5)+AA5)+AC5
Hope the Gurus can please let me know what is the cause.   As the file is not a confidential one, just a simple data file, I could upload it here for u to examine and let me know the problems.  Thank u.
0
Question by:jegajothy

LVL 19

Expert Comment

ID: 39957718
#Ref! means there was a formula with reference to something what is not available now.

when I look at formula
=((((((((((G5+I5)+K5)+M5)+O5)+Q5)+S5)+U5)+W5)+Y5)+AA5)+AC5
matemathically I do not see anything wrong, but logically brackets have no reason to be there since it is a bacis count so the same result will be when
=G5+I5+K5+M5+O5+Q5+S5+U5+W5+Y5+AA5+AC5

if you can attach a sample of your Excel it would be helpful
0

LVL 39

Expert Comment

ID: 39957719
Well that formula will show #Ref! if any of the underlying ranges's value has #Ref!.  Loading your file would simplify things indeed.

THomas
0

Author Comment

ID: 39957756
here is the file, nothing confidential in it.   Hope u could please also see if there any other type of errors besides the one I mentioned.  Thank u.
0

LVL 39

Expert Comment

ID: 39957767
0

LVL 23

Accepted Solution

Michael74 earned 500 total points
ID: 39957854
Select one of the cells containing #ref and use Trace Precedents and Trace Dependants (On the formulas tab). This will assist in tracing the issue and correcting the issue

http://dummy-essentials.blogspot.com.au/2009/06/error-ref-in-excel.html

Michael
0

Author Closing Comment

ID: 39963913
Thank u bravo, well done.  y our solution provides the answer.  Thank u again.
0

## Featured Post

### Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filledâ€¦

#### Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!