any best practices or workarounds lists to deal with large excel files generated by bobj
There is an Excel file that reports all timekeeping actuals for a given year. In the beginning of the year, the file is easy to use, but after a couple of months, it houses so much data that filtering and sorting are difficult making it hard to use and extract data. By the end of the year, it is up to 800k+ rows.
This data is dumped from BOBJ into Excel and the file is used many depts. It is valuable to see the entire year at once rather than only month by month. The report is updated weekly.
There have been some complaints lately of how difficult the file is to use.