Hello,
I have created one excel file, in that I have used vlookup function to calculate stock in different sheets.
I have created total 4 sheets.
1. Items
2. Inward
3. Outward
4. Balance Stock
Now, when I do entry in Inward/Outward it takes more time to open/save/copy.
It is showing calculating 2 processors. When this finishes after I can do another thing.
Also excel files are not responding.
Any alternate option or solution of above problem.
Please help me.
Thank you in advance....