You'll get nowhere with spreadsheets unless you are willing to learn and put some time into understanding them.
Unanswered topics Active topics Search FAQ Login Register Board index. This is a forum peopled by volunteers - nothing official. User community support forum for Apache OpenOffice, LibreOffice and all the derivatives. Try to remember that this isn't tech support. Not try to point me in the right direction when I have no clue to start with on how this works, and I'm not interested in learning either. It doesn't work for OO.o, and I'm asking someone to figure out how its supposed to be so that it does work. So, telling me "it works" if you put it into some test sheet instead of looking at the huge book I've linked to that has several sheets and is doing these lookups across sheets using a special "Matrix" sheet and stuff. In OO when I view any of the data fields I see Err:502. So, obviously something is different between the two. I have been sent a more than normal complex workbook with many sheets. Sometimes you'll get a #NAME error also when you don't have the proper Add-Ins. Location: Sarnia, ON Re: Why am I getting Err:502 on my formula by RusselB Tue 6:44 am Personally I'm surprised you don't get an error on the SUMs you posted, since they do cross multiple sheets. You only get the #REF! error when you don't have the Add-Ins installed. It does work in Excel 2k3 and 2k7 as advertised when you go to Tools->Add-Ins and check all the ones needed for this. I'll reiterate: I didn't author these sheets.
0 kommentar(er)
