Circular reference error

**Nitro2481** · 04-07-2015, 07:42 AM

Hi Guys,

I expect you will need more info but the basics of it is, I have some circular refrences set up so that when a value is input in say cell b1 then a static date auto populates in A1. To do this I had to go to options, calculation, tick the box for iteration then change the iteration amount from 100 to 1. Thats all grand and works well. I also have the spreadsheet set up that there is a timer on it so if someone else has it open and has not been active on it for 10 minutes then the workbook will save and close. On some occassions after it has timed out and I reopen the workbook I get the circular reference error and I then need to go back to options, calculation, tick the box for iteration then change the iteration amount from 100 to 1. Like I said this does not happen every time the timer runs out but some times. I'm not sure if that is the reason or if there is another reason. Any ideas greatly appreciated. I have attached a sample of the worksheet I'm using. I have removed some sheets due to size. I have made some changes over time to the VBA codings so I'm worried I might have made a mistake somewhere and there might be a code amoung all the code.

**LJMetzger** · 05-08-2015, 01:55 PM

Hi Matt,

a. I haven't found anything in your code that turns the AutoFilter off, so I can't comment on that problem.

b. I haven't tested the code, but each time you protect a sheet, you probably want to mimic the following code you have in your Finished() routine in Module 5. I may help you with your Sort problem.

Please Login or Register  to view this content.

c. Try adding the following code in the 'ThisWorkbook' Module:

Please Login or Register  to view this content.

I hope this helps.

Lewis

**Nitro2481** · 05-08-2015, 06:13 PM

Originally Posted by LJMetzger

Hi Matt,

a. I haven't found anything in your code that turns the AutoFilter off, so I can't comment on that problem.

b. I haven't tested the code, but each time you protect a sheet, you probably want to mimic the following code you have in your Finished() routine in Module 5. I may help you with your Sort problem.

Please Login or Register  to view this content.

c. Try adding the following code in the 'ThisWorkbook' Module:

Please Login or Register  to view this content.

I hope this helps.

Lewis

Hi Lewis.

Have given this a quick try. The sort issue worked and is fixed. The circular reference issues briefly looks like it worked too. I'll have to trial this with the other users for a few days but looking good. Just one thing over noticed. If I press the x in the top right hand corner to close the workbook only, it brings me back to the log in screen. It doesn't close completely. I have to press the x to close the excel program which is a little annoying when you have other workbooks open. Any ideas? Should I open a new thread.

Thank you
Matt.

**Nitro2481** · 05-10-2015, 03:43 AM

Hi Lewis

Have given this a quick try. The sort issue worked and is fixed. The circular reference issues briefly looks like it worked too. I'll have to trial this with the other users for a few days but looking good. Just one thing over noticed. If I press the x in the top right hand corner to close the workbook only, it brings me back to the log in screen. It doesn't close completely. I have to press the x to close the excel program which is a little annoying when you have other workbooks open. Any ideas? Should I open a new thread.

Thanks Matt.

**LJMetzger** · 05-10-2015, 07:48 AM

Hi Matt,

If I press the x in the top right hand corner to close the workbook only, it brings me back to the log in screen. It doesn't close completely. I have to press the x to close the excel program which is a little annoying when you have other workbooks open. Any ideas? Should I open a new thread.

I was able to duplicate the problem, and the following code which is also in post #2 above, should solve the problem.

In the Thisworkbook module:

Please Login or Register  to view this content.

Lewis

**Nitro2481** · 05-10-2015, 08:04 AM

You did it again Lewis. Worked perfectly. Thanks a mil for all your help.

Matt

Circular reference error

LinkBack

Thread Tools

Rate This Thread

Display

Circular reference error

Re: Circular reference error

Re: Circular reference error

Re: Circular reference error

Re: Circular reference error

Thread Information

Users Browsing this Thread

Similar Threads

Circular Reference Error

Circular reference error

[SOLVED] Circular Reference Error Even Though There Is No C.R.

[SOLVED] Circular Reference error...

[SOLVED] Circular reference error

Bookmarks

Bookmarks

Posting Permissions