Software

Question

Circular Reference Warning

I have a user that is getting an errror message when she attempts to open a excel spreadsheet she works on every week. She has a Dell Latitude D630 with XP Pro and Office 2007 fully updated. Spreadsheet is saved to 97-03 compatibility.

When she trys to open the spreadsheet the circular reference warning error appears. If i press cancel to create a circular reference, the error window goes away but the workbook/spreadsheet doesn't appear. It is blank. I'm not a 100% sure if its supposed to be a circular reference or not, it is an insurance document so there are a good amount of formulas wrriten.

She was able to work on this last week. Now she can't, I'll find out what she might have changed last week.

Solution?

Now, she can't open up any of her spreadsheets. Do you know what is causing this, and how to resolve this major issue?

On the first spreadsheet I tried to delete the formula because I just wanted to see the workbook. After I deleted the formula I still couldn't see the workbook. I have steps on how to fix this through Microsoft but since I can't see the workbook or work with it, I can't find a way to fix this issue.

My mistake

The other workbooks are showing different symptoms. There is only the first one showing the circula reference error message. When the user trys to open the other spreadsheets, nothing opens up. No error code, no new workbook. Just an empty excel window with toolbars.

Excel file with circular reference will not display

I have a file which Excel thinks has a circular reference. I have set the options to Manual calculation and 1 iteration and opened the file and clicked CANCEL to allowthe circular reference. Excel appears to do nothing - the screen stays blank. However when I try to close Excel, it asks if I want to save changes to the file, implying it is open. Also, when I use VBA to look at the project, the file and its sheets are there. So it is open - it just is not displaying it. How can I get at the file in order to remove the circular reference?

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer". .

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.