Not able to export Suppliers

I am trying to do the following:1. In advanced search, once I get a result based on my criteria I click the button: 'Export All'.

2. I select viewer as 'Excel 2007' and click 'Next'.

3. In the pop-up message I chose to open the file.

4. I enable the macro in the file once opened.

5. The macro runs and opens a new window: 'Processing: Create Document'. In this window it is stated: 'Document formatted' '0 Records downloaded' and 'Do not close this window until processing completes.'

The issue is that the window stays the same even if open more than 1 hour. It never completes. After a while I can see an error message in Internet Explorer: 'Your document could not be created'.