The screen gets crazy and doesn't refresh properly and the calculation method turns manual

Hi all

I am in a big (at least for me) project for a NGO upgrading a tool to forecast. To make everything simpler I basically collate data from 600 tables in different sheets. Everything goes to 'tChannelsCollation' which is a master table from where I want to build pivot tables.

I don't know what happened or what I did but the screen started to flicker and not refresh. It was like the sheets were temporally overlapped and everything looked a mess. At the beginning after scrolling up or down was fine but got worst.

I tried several things looking in the internet and I realised that the calculation method were turning manual all the time after I execute the following Macro (which is the main one and can be executed from "HOMEPAGE")

Please Login or Register  to view this content.

I completely lost the compass. I hope you can help me out with this. Just in case you need to see the workbook you can download it here. I didn't attach it because it's around 12 MB (I don't know neither how it got from one moment to other so big)

Please Login or Register  to view this content.

Beside all this I have had another issue (I think it's not connected to the previous ones). Every time I save as... with a new name all references in the pivot tables keep static to the previous file. I read in some forums that this was a bug in Excel 2013. Is it right? How do I solve this out?

Summarising:
- Screen gets crazy refreshing and sheets and are seen overlapped after I manually change the calc mode to automatic
- Calculation method is changed to manual after execution of macro Extractor
- Pivot tables keep static the source with references to previous files when saving with a new name

Last but not least, despite my desperation to find an answer I need to apologise because I have been crossposting without knowing that this was inconsiderate. Here it's the link from the other forum http://www.mrexcel.com/forum/excel-q...ns-manual.html.

Many many thanks.
All the best,
Gerónimo

Dear folks,

Here are some print screens of the issue I am having.

I have realised that you will only be able to detect it if you, after download the file

1. turn calculation mode to automatic
2. click load button and wait a minute until the macro Extractor finishes
3. check that calculation mode turns manual, turn it automatic again and play with something like a drop down list for example

After that it keeps crazy and the screen is never refreshed properly again.

Here are a couple of images to illustrate the issue. The first image shows how the sheet is, the second one the mess (it's the same sheet)

how it should look like the HOMEPAGE.png

or like this.png