Hi

I have a excel workbook that users use for LEAN rapporting. On the first sheet they enter date, department in a form...and it works fine except it is very slow when user klicks on Save button which is on the same sheet.

The workflow is like this.

Comboboxes fetches menu items from MenuItems sheet(works 100%)
When user is finished with the form on Input sheet and klicks on Save button -> 2seconds later info is written to the Database sheet.

For some reason it takes almost 2sec to update the Database sheet. I have been watching on two screens the update and it gets slow when it fetches data from Department combobox and then it goes fast until it fetches data from Status combobox.

I can't see why is this happening so maybe some of you guys could help me solve this mystery?


My enviroment: Windows 7 pro x64 and Office Pro x32 and you can find the file here:
http://dl.dropbox.com/u/32248859/Lea...2012-test.xlsm