Whenever I enter my nox pear cactus into the sheet, it errors on me and asks if I want to de-_bug_. I assume it means de-_bug_ the macros, but I don't dare, LOL! Anyone else had a problem with it? I am using it in compatibility mode because I have a newer version of Excel - I have to tell it to enable the macros each time I open up the file for the day - is that part of the issue?

Thanks for any help. I LOVE the sheet and am desperately trying to get the last two magic plants by using it!

I just looked at my sheet and I have it added with no problems, so I'm not sure Penn.

delete the file and download it again from the guide section. if that does not fix the problem, i will investigate it some more.

I keep getting the de-_bug_ pop up too... happens if I enter more than 4 plants on the sheet
I have 2003 version of excel
although I must admit this is the first time ever I have ever used excel .. I always wondered what it was for lol

i created it with Excel 2000 on a 5+ year old computer and I suppose the problem could be that I am using such an old version. I don't have access to a newer computer or version of excel though to try to fix it on. If one comes along and bites me I will upgrade things thank you for the bug reports.

I'm running Excel 2000 too. I've downloaded the file (three times now) and each time it loads nicely, and I can key in or select plant names, but when I click on the pivot table I get the message that it's causing problems and it closes Excel. I can't think what to try next.

I think there are two different Excel files being discussed here. Borg's uses VBA, while 5p1d3r's uses a Pivot Table. If it's the Pivot Table that everyone is having trouble with, Borg can't fix that for you.

I am using excel 2007 and I got the same error as Penn32.

First I click the plant then on "end" then "Add plant" then "end" again. It take some time but it work.
But it would be nice if it can be fixed

Thanks, LadyCFII, yes, I'm getting confused trying to figure out all the spreadsheets.

It seems that when I have a lot of plants on the left side of the grid and then add something on the right side (like a nox pear cactus, for example), it blows a gasket trying to figure out all of the really remote combinations. Sometimes it goes through anyway and sometimes not, but as long as I get the simpler combos laid out for me, I'm fine. LOVE the sheet!