Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Calculation Doesn't Move, Calc Sheet Works fine...

Status
Not open for further replies.
aprunkard

aprunkard

Technical User
Oct 29, 2004
52
0
0
US
I have a six sheet workbook. Four of the sheets have some multi-critera VLOOKUP formulas and one of them has less then 500 rows of data but three IF formulas per row.
I turned off the auto calc to add some data to main sheet b/c it would take a while for the other sheets to update.
But when I turned the auto calc back on it just sits at 0%. I can manually calc each sheet indivdually and it instantly calcs every sheet.
Using F9 doens't work either. If I leave it to calc before saving Excel locks up.
I tried removing the IF formulas and it still sticks at 0%.
HELP!!! Please...
 
Sort by date Sort by votes
Nevermind... I eneded up recretead the data sheet in a new file with the other other sheets.
It works fine now. Just a pesty MS bug.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
172
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
Excel 365 (2016) Working to auto-populate dates 3
Replies
13
Views
245
ladyck3
ladyck3
ladyck3
  • Locked
  • Question
Excel An occurance on Sheet #1 - from A:A - want to find the total of $ in G:G ... on Sheet 2 6
Replies
14
Views
213
SkipVought
S
rk68
  • Locked
  • Question
matching data from one excel sheet to another
Replies
6
Views
136
rk68
rk68
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
174
ladyck3
ladyck3

Part and Inventory Search

Sponsor

Back
Top