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")
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)
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
Bookmarks