We have workbook which contains input ready queries. When user enter planning values and save the inputted values then it is taking more than 30 minutes to save the data to real time infocube. We have some VBA code on this workbook which is used for formatting and displaying pop-ups when user enters wrong values. Even though we have VBA it should not be taking 30 mins to save.
Please suggest what might have went wrong.