POI shows error

John, send me the file via email and I'll look it over, sometimes 4 eyes can spot what 2 have missed.

johnm405 if this is the same file you have posted on POI Factory I don't see a line 42 but see errors at line 4 and 27 in column a for the longitude.

I had Flaco check the file also and he found the missing minus signs. I corrected them but still get an error for a like that is not there. Also there are some quotation marks open that I didn't put there. I am going to work on it later today abut need to finish a honey do that I been working on for over a year.

John, usually when you get the error message you originally described, open the file in Excel. If something is in the lines after the "error line" (42 in your case) correct line 42. If there is nothing in line 42 or after it, highlight line 42 and a few lines after it. Then delete the highlighted lines.

Thanks I did delete the 4 comming soon lines and I did see some quote marks in lines after when I used notepad but there is something very small that I am missing I think hope to find it today.

Now that you have found and corrected the items using excel, open it in notepad. Any leftovers should standout.

That is what I suggested to John last night, with notepad you can easily find the extra stuff and the missing ones.

I started using Excel for creating files but after trying with notepad I never went back, I find notepad easier to copy paste and move stuff around.

Thanks to all. I am done with the honey do for now so will be looking for the other error and then hopefully can post and update to the listing. I am going to give notpad a try fro the next one

Finally. Found the errors and corrected and updated the file in the POI list. There was a formula in one of the long block, a couple of minus missing and quotation marks lower in the spreadsheet that were not showing up. Used notepad and they were there just as plain as day. Thanks to all that helped me fix the problem. Also if anyone has down;oaded the winger grill & bar poi under restraunat there is a new update as of today.

Dear GPF,

Thank you. I had been having such a problem with three of my POI files. Opening each file in NOTEPAD allowed me to see the spurious commas that had somehow arrived in the file. When I have tried to find these pesky commas using EXCEL (even after seeing them in NOTEPAD), I was unable to see them; however, I was able to remove them using NOTEPAD. I had saved the unedited versions of the three files in case NOTEPAD screwed them up but NOTEPAD seems to have solved the problem.

I am most grateful as EXCEL was providing no solace. I should note that in each file these spurious commas arrived on a line later than any data.

david

David,

You are quite welcome. It is just one of the many tricks I picked up from this site and was glad to pass along.