Solved

Excel 2007

Posted on 2014-03-26
6
315 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
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

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.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
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 …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

832 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