Solved

Excel 2007

Posted on 2014-03-26
6
318 Views
Last Modified: 2014-03-29
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
Comment
Question by:jegajothy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 19

Expert Comment

by:helpfinder
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

by:nutsch
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

by:jegajothy
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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 39

Expert Comment

by:nutsch
ID: 39957767
The upload didn't take. Can you please try again?
0
 
LVL 23

Accepted Solution

by:
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

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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
split data by day 21 35
Search for a certain number and select cells using VBA 9 19
Slicers by Groups in Excel 7 22
Excel format formula with percentage 3 9
My experience with Windows 10 over a one year period and suggestions for smooth operation
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question