1
General discussion / Re: Decimation
« on: June 17, 2012, 02:53:55 am »
When I get #NAME errors it's because I've renamed an item while having it equipped. Resolving is either an Undo or if you've already saved it, a re-download of the spreadsheet. Let me know if this is what broke your sheet!
---------------------------------------------------------
Edit: I should add that it's perfectly fine to change the affix values of an item while having it equipped, the spreadsheet doesn't like it when you try to rename it though.
So, When I open a brand new spreadsheet.. I'll change the weapon from what is currently is, to a DIFFERENT weapon and it breaks immediately.. Is the only option to keep the current weapon and just change the numbers..or?
This is mainly the issue I was having, the sheet simply breaks when you try to adjust anything in the weapon slot.
I've tried setting the Weapon to "None", then picking a different weapon, picking the same default weapon it's still broken...
You don't have this issue Super?
EDIT: I'm using Excel 2007, could this be the issue? And if not, I can't change ANYTHING on the weapon slot (affix,name,dmg, etc) without it breaking the sheet.