Bulk Upload Spreadsheet Category Error
New here and I didn't find anything regarding this error so if this is a repeat, my pardons.
- Downloaded the eBid spreadsheet and opened it in Google Docs.
- Checked the categories that I was interested in the Categories tab.
- In the Add Listings Here tab, column B, Categories I attempted to add number 32621 (Coins & Banknotes Exonumia:Transit) and received the error, "There was a problem
Incorrect eBid Category Number - eBid categories can be found on column A of the CATEGORIES tab of this spreadsheet"
- Looking at the Data Validation Rules for column B it states, "Value is less than or equal to 20000". This should be changed to the largest number in the Category ID List.
Thanks.
1 Attachment(s)
Re: Bulk Upload Spreadsheet Category Error
I did a trial entry in Excel in the downloaded Ebid spreadsheet and Excel would not allow me to enter 32621 anywhere in Column B
Attachment 65418
.
However, if I tried adding 32521 in my recently uploaded spreadsheet which started as a blank spreadsheet there was no "incorrect category number.
Possibly there may be an old data validation ruie lurking in the download, and it has not updated to 34757, the highest number I see in Antiques, but if you copy the Ebid downloaded spreadsheet across to a new spreadsheet, there should no data validation rule.