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
1 Replies
Sharad
(Accounts Officer)
(33 Points)
Replied 09 January 2011
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
- RCM. ON RENT PAID BY COMPOSITION DEALERS
- Development cess and RCM
- Mistake in challan 26 QC while depositing TDS for
- NGO work related
- Query on tax deduction on source
- Best Game Platforms
- Need help regarding a non-functioning Private Limi
- RCM on payent of rental charges of commercial prem
- Manufacturing under shops and establishment act?
- If registered person renting immovable property in
Related Threads
Trending Online Classes
-
25 Hours GST Scrutiny of Return and Notice Handling(With Recording)
Industry Expert14 February 2025 -
Survey, Search and Seizure under Income Tax Act 1961
CA Hari Agarwal
CAclubindia
