Hi all!
I have a bunch of excel spreadsheets that overlap somewhat, and I am thinking about going to Access. The overlapping data entry is not a major issue for me, but I have one particular spreadsheet where I can't seem to get pivot tables to behave in unless I lay out my data in a really bizarre way, which is very challenging for entering/manipulating data.
Feel free to take a look at my current workbook and layout. The data tab is how I would like to have my data, but the list tab is how I have needed to put my data in order for pivot tables to recognize the dates as dates and not text. The Vertical tab is how I might want one of my reports to layout and the Horizontal tab is how my report needs to be laid out in order for the chart to show correctly. The Chart (Horizontal) tab is one of my main reporting goals.
The big problem is that if I keep my data in the original 'data tab' format, the pivot tables don't fully work for me. But if I was to change to the 'list tab' layout then I would end up with around 200,000 rows.
So do I have a good case to be looking at Access? Will I ultimately recoup the time setting up the database in time saved using it? And how should I design my database?
Any help very much appreciated. Thanks![]()