I have several Excel files that do a VLOOKUP for data where I have to use the file path for access to the source files (e.g., C:\Users\User Name\file path). Since I use Dropbox to enable use of these updated files on two other computers, I need to have the path names identical for the VLOOKUP...
We work for ITO-Client-Management team. There are some issues while using the MS-Excel 2010 which we work on daily basis. File size is 12.5MB and has 42600 plus rows and 17 columns.
1st ISSUE:
When a formula (i.e.: COUNTIF, VLOOKUP) is run, it takes lot of time (30min) for compilation. The...