You need tp "Export Values". There is a small glitch in the VB-code doing this though. I reported it over in the other bug thread. If you are a bit familiar with debugging this kind of code have a look over there.pa12ick said:I changed the max Hero from 100 to 300 in the xls file, to play around with the magic promotions for Heroes, but in the game it stayed at 100. I made sure that the file was saved correctly. Do I need to "Export Values"? If so, that gave me a laundry list of errors... Am I doing something incorrectly?
(I'm sorry but I'm in a hurry and cannot rewrite it at the moment, perhaps a bit later.)

Reference to the earlier post:
http://forums.civfanatics.com/showpost.php?p=4068600&postcount=29