Skip to Content
0
Jan 10, 2023 at 09:22 PM

any best practices or workarounds lists to deal with large excel files generated by bobj

48 Views

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.