Hello everyone, i had a trouble now, i'm in charge of the budget monitoring, i'm usuing data from a excel file that is generated by the finance manager, this excel file it's a report from SAP Business One, a report from a query made there, so after a couple days this excel file has become a monster (almost 100 MB) and we aren't in the high sales months, so my question it's is there a way that SAP can export the file as a Data Base or to a power pivot so i can manage it? our IT team it's working in a better way to obtain the info, but for now i have to deal with it as is now. I try a power povit and a access data base but none of them have work well.
Thank you all for your time, kind regards
by the time i wrote this there are 221409 registers