Limit Excel Database 追蹤
I'm working with a database in excel to generate my entire product label. Because there are quite a lot of data entry fields and data fields per product the file is quite large in overall size and shape. There is only one sheet used for the data per product, but there are several sheets to comprise the data. This has to be done for language changes.
I am experiencing that when I add collums that there is a limit to the width of your overall table. Not knowing where this line is, is difficult to work with since I am still altering the database quite a bit before it will be finished. I would like to get the maximum amount of data on each individual row to prevent future problems with data entry.
Could you please let me know what the limit is. The last working version of my database had 7 sheets, in which the data entry sheet was From A-DE (109 columns) to roughly 6.500 records (6.500 rows).
Thank you in advance!