PDA

View Full Version : overloaded excel workbook - ETL replacement ?



papermonkey
07-26-2018, 04:26 AM
hi,
the XL am using is overloaded with data and too many validation formulas for 15,000 rows. all these validations execute everytime the vba macro runs in the background or everytie i hit the save button. can you suggest a different structure to store my data? any ETL ? thanks.

macropod
07-26-2018, 04:39 AM
Cross-posted at: https://www.mrexcel.com/forum/excel-questions/1064562-overloaded-excel-workbook-etl-replacement.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3