• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

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 :
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.
1 Solution
helpfinderIT ConsultantCommented:
#Ref! means there was a formula with reference to something what is not available now.

when I look at formula
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

if you can attach a sample of your Excel it would be helpful
Well that formula will show #Ref! if any of the underlying ranges's value has #Ref!.  Loading your file would simplify things indeed.

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.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

The upload didn't take. Can you please try again?
Michael FowlerSolutions 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


jegajothyretiredAuthor Commented:
Thank u bravo, well done.  y our solution provides the answer.  Thank u again.
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.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now