I created a spreadsheet for archery scores. I added some dummy data, had things running, great.So I decided to start fresh. I cleaned on the Input cells, and when i go and add data back in, nothing calculates.Auto Calculate is on. I open other spreadsheets and they work. below are some of the...
Hi,
I have built a very complicated financial spreadsheet at work that requires MANY circular references. I recently needed to change something and add another circular reference, and now that section of the file is not calculating correctly. When I go to into the "Evaluate Formula" it...
My 300kb Excel 2007 spreadsheet won't calculate simple formulae like sums, additions and subtractions. The spreadsheet also has CSEs, sumproducts, iferrors, maxifs, etc.
My setup:
Computer: Compaq laptop NC8430
CPU: intel core duo, 2 ghz, 3gb RAM
OS: XP service pack 3
Excel: 2007
I have...
Hi,
I'm using some vba code to insert a column and then place a formula for a vlookup. But the resulting cells with formulas are not calculating instead it is showing up as a string.
Also, as a test I could not place in a basic formula into thos cells after the script ran: I put in...
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.