We would like to design the attached excel file in MS Access so that we can work with bigger database also.
We are attaching herewith an excel sheet contains so many sheets but only starting 6 sheets are our inputs and all remaining sheets are for reporting purpose only which are being maintained by using vba also. The attached file contains the VBA script also. In the attached file we had coloured the input fields as follows :-
1) Green Colour - We shall make manual Entry
2) Orange Colour - Result will come automatically from the link but we can change the input
3) Red Colour - Result will come from designated link and we cannot change the input.
As we are using so many formulas and pivot tables in the file it is slowing down our working speed too much as such we require a software which will use MS Access for maintaining the database and MS excel for regular input of the new datas and reporting formats. Some reports may be crated in MS access also by using Query reports.
Contact Arvind Harlalka 98300-25765
Hello, I'm not sure if it is possible but if you can update your Excel to 2007 or later I can get this file down in file size from >14MB to ~3MB. It would allow you to continue to run Excel and would be much faster and not require anyone to learn Access, which can be challenging for some people.