Huge Excel needs fixing -Expert Only - on hold while looking at propsals already sent
- or -
Post a project like this- Posted:
- Proposals: 24
- Remote
- #1724975
- Expired
Description
This excel took months to creat and all the fomulas that can be deleted have been. so that will not fix the issue. I have to get it to run quicker, 15 people need to use it and although they are not using it at the same time they need to go in, put int he info and get out quickly. even closing this program takes 15mins as does saving it.
Expert only please
Sophie S.
100% (6)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Sophie,
Is this a spreadsheet solution that has evolved over a period of time, or has it always be a slow process that has been getting slower? Like another comment posted, is it possible to provide a version of the speadsheet with "dummy" data so that I can analysis how the spreadsheet and associated files are functioning. Before providing a quotation for providing a solution.
As an aside, what operating system are you using and hence version of MS-Excel? -
Dear Sophie
It doesn't fix by split it, maybe work for one week, then you see the same issue in all separated files.
If you can share it with me, I'll analyze and let you know conclusion as well
Don't need to accept my proposal
thanks' -
Hi Sopie,
This sounds an interesting challenge! Is there any way you could share the spreadsheet (using dummy data if necessary). I feel that without seeing the workbook it would be unfair to commit to being able to provide a speed increase -
Why do not you seperate huge excel file into small modular excel files?
If you have problem in the file, you may have so much difficulties.Sophie S.25 Sep 2017If i could do that I would not be asking to pay someone to fix it. The excel creates multipul reports from the information in different sheets.
Emrah K.25 Sep 2017My aim in asking was to learn if it was allowed to split excel file into separate files. Can we split it?