Excel 2007

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.
jegajothyretiredAsked:
Who is Participating?
 
Michael FowlerConnect With a Mentor Solutions ConsultantCommented:
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
 
helpfinderIT ConsultantCommented:
#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
 
nutschCommented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
jegajothyretiredAuthor Commented:
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
 
nutschCommented:
The upload didn't take. Can you please try again?
0
 
jegajothyretiredAuthor Commented:
Thank u bravo, well done.  y our solution provides the answer.  Thank u again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.