Dear members,
i had a doubt in excel.
vlookup - while given in excel sheet, it is taking enormous time for every time when we close the file.
why?
vlookup - do any one knows any technical details please share
Menu
v look up query
Replies (1)
Vlookup/Hlookup functions make file size very heavy. Check file size. See if it is taking lot of time on saving the file during the work.
In case, size of the file is very heavy, and you dont need the Vlookup/hlookup function anymore, copy and paste special the values fetched by the function. This way your file will reduce, however, anytime if there is change in the master data from where you have fetched the values, you need to update your file by putting vlookup again.
Regards,
Sharad
Recent Topics :
- FAI & FAST-DS 2026 query
- Is GST registration mandatory in this case
- Buying a residential flat in Goa: should my wife b
- Income tax filling
- Applicability of RCM in the case of import of serv
- Confusion in gst registration for service category
- Itc claimed from return defaulters
- Gst input credit
- CAN PARTNERSHIP FIRM SIGN SERVICE AGGREMENT WITH A
- E-waybill
Related Topics :
CAclubindia
