Calculation table working with circulars

JamesMc007

New Member
Joined
Sep 7, 2009
Messages
2
Hi all,

New to this board, but got a problem I'm hoping someone here can help with.

I'm working on a financial model which has a circular formula in it, and unfortunately, there is no other way to do this calculation without using a circular - in this case it's a necessary evil.

We also need to have a calculation table, which does not work with having a circular at all.

I'm trying to find a way to make the two place nice with each other and have thought there might be a way using macros. Is there a way to control the rebuilding of calculation tables? For example, to run a macro which would make the circular calculation for each column of the calculation table?

Any ideas would be much appreciated.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

sanrv1f

MrExcel MVP
Joined
Jan 1, 2009
Messages
3,474
Office Version
  1. 2016
Platform
  1. Windows
Hello and welcome to the board,

Using a macro you could convert the circular cells to values, but it would be better, if you post some sample data and expected results
 

JamesMc007

New Member
Joined
Sep 7, 2009
Messages
2
To give a little more info, the calculation table would be a 1-variable table, to calculate the model at various revenue levels. The circular formula would need to be run at each level of revenue.

I was thinking about having the the macro paste as values the result of the circular, but it didn't work. I wasn't able to figure out how to get the macro to run at every column of the calculation table. I put the code in worksheet_calculation, to run when the cell that the calculation table uses as its 1 variable, but the macro didn't show it changing at all.
 

Forum statistics

Threads
1,144,374
Messages
5,723,988
Members
422,529
Latest member
mbilal429

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top