Question about Microsoft Excel for PC

2 Answers

Circular reference errer in excal file in office 2007 Problem. when i open excal seet and whant to change and save. then pc show problem? ple help me shamsherpatel

Posted by on

  • magbul Jul 04, 2008

    I get error message
    "Circular References Error" when i open a XL file, Pls give a solution.



    Thanks
    Mohamed




  • Lagusaya2 Dec 10, 2008

    But I can't even open the file to correct the error...now what do I do?

×

2 Answers

If you get this error then you need to find and correct the offending cells.

First click OK on the initial warning message. The Circular Reference toolbar and a help window should open (if not then go Tools -> Customise -> Toolbars tab, and check Circular Reference, then click close).

On the Circular Reference toolbar click on the down arrow of the text box which will show a list of offending circular cells. Select one and you will be taken to that cell, once there correct the formula. If you have further circular cells then select the next one from the list.

Regards.
Dan.

Posted on Jul 17, 2008

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

Hi shamsherpate

In order to remove this error message you need to locate and remove the incorrect references:

On the Formulas tab, in the Formula Auditing group, click the arrow on the Error Checking in-group button, point to Circular References, and then click the first cell listed in the submenu.

Tip You can move between cells in a circular reference by double-clicking the tracer arrows.
Review the formula in the cell. If you cannot determine whether the cell is the cause of the circular reference, click the next cell in the Circular References submenu.

Note The status bar displays the word "Circular References" followed by a reference to one of the cells contained in the circular reference.
Continue to review and correct the circular reference until the status bar no longer displays the word "Circular References."

Regards,
TheAssembler

Posted on Jun 06, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Microsoft Project 2007 Corrupting Data


Other solutions are to recover from backup. Open on another machine with Project or repair the User Profile. It may be corrupt. If you can log in with another username to the PC and try to open the file.

OR:

1] Go t File --> Options --> Trust Center --> click on Trust Center Settings --> Select the option "Allow loading files with legacy or non-default file formats" and try opening the file.

2] Open a blank project and try inserting the problematic file and try opening it.

Another method might be applied in case severe .mpp corruption http://www.mpp.openfiletool.com/ MPP Open File Tool

Jul 26, 2015 | Microsoft PROJECT Computers & Internet

1 Answer

Excel 2003 worksheet slow in 2007


Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

1 Answer

Unable to open EXCELL 2007 workbook containing a circular reference problem.


open Excel
Click the 'Microsoft Office' button and click 'Excel Options'. Click the 'Formulas' button. From 'Calculation options' section, un-select the 'Automatically' option. then use file->open->yourfile.xlsx. It should now open. Find the circular reference and fix it. Then save the file.

Mar 18, 2013 | Microsoft Office Excel 2007 Full Version...

1 Answer

My Excel 2007 status bar shows the words "Calculate" even though my calculation is set to automatic. From my experience with the prior version of Excel, this indicates a circular reference error....


A couple of possible causes:

Setting Workbook.ForceFullCalculation to True will cause this.

The Iteration Option is turned on and the workbook contains circular references. Turn off Iteration (Tools-->Options-->Calculation) and press F9-- it may show "Circular Reference."

Jun 20, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

What is compatible mode How it will be converted to Full version


Compatibility mode helps users collaborate with those using previous versions of Word, Excel, and PowerPoint. A file created in previous versions of Office, such as .doc, .xls, and .ppt, are fully functional in compatibility mode in the 2007 Office system. Compatibility mode ensures that the 2007 Office system can open and save files in from previous versions of Office without converting them to the new file formats in the 2007 Office system.
Just select "save-as" and save the file in 2007 format.....And when you will open the newly saved file...It won't show "Compatibility mode".

Have a nice day :)

Nov 07, 2010 | Microsoft Office Standard 2007: Windows

1 Answer

I can't open word document


You need to be sure it is a word document or a word compatible file

Also if it was made and saved from office 2007 then there are issues with the way office 2007 saves files and you would need to download the

office compatibility pack.

Aug 31, 2009 | Microsoft Office Word 2003 for PC

1 Answer

Excel won't let me save my 2007 file in 2007 format


Is the top choice on the Save As menu "Excel WorkBook"? If so, then that is the 2007 version. It should change the extension on the saved file to xlsx

Apr 10, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

How to open office 2000-2003 PPT files in Office 2007


chk blind guess.......

change the formet PPTX to PPT then open it

or open it on office 2007 and save it in ppt format

Mar 28, 2009 | Microsoft Office 2003 Pro (269-07387) for...

2 Answers

Can't reopen circular reference file in excel


  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Nov 05, 2008 | Microsoft Excel for PC

2 Answers

Microsoft activation assistant unable to launch


Try OpenOffice instead http://download.openoffice.org/index.html ... it's free, forever, not just 30 days. It can read and save Office Files (Excell, Word, Powerpoint, etc.), it's Open Source and has all the features you are likely to need. Versions avail for Mac, PC, Linux. 

I switched a month ago, after using MS Office products for a decade .... I don't miss them at all.  I can read all my old files and save them in original MS format, or in the Open Office format.
Try it ... you might like it.    You could always send them a few bucks if you feel it's worth it.
MS code == buggy. Open source code gets fixed because any qualified programmer can look at the source code and contribute a fix.  Considering open source is developed by a rag tag world wide team of programmers,  you will be amazed that the quality is frequently better that MS.  Sun Microsystems has donated a slew of money (programmer time, and hard cash) to developing Open Office.  
Many companies have great, high quality, ad free, software for free, like AVG Antivirus Free version, etc.  
If you try OO, let me know what you think.
...ajm

Oct 29, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

1,352 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...