Dear Experts,
I am working on a project where a more than 50 worksheets being used as data base file. out of 50 work sheets i made 10 sheets for different types of reports.
But the file size become big size (more than 50 MB) and it perform very slow.
Now i would like to split work sheets in different file.
My question is that if i will update database files and close tha same after saving.
may i access reports easily & faster during database files are close.
Or suggest me other easiest way (eighter reduce file size or some different method)
Please suggest (i am trying to post the same file in zip mode but file size is too big and unable to upload)

Thanks in advance