Why is “Application.ScreenUpdating = False” not working pivot table?

[GrabberHackman]

Hi friends, I have a question to ask you, I have created this code that allows me to update a pivot table to the various data of the column a. The problem is that I would like to make these changes in the backgroud. but unfortunately nothing seems to work.
https://youtu.be/3xiR3G_2tJU
code worksheet

Please Login or Register  to view this content.

code module

Please Login or Register  to view this content.

[Artik]

You probably need to turn off background refresh for the PivotTable.

Artik

[GrabberHackman]

where is the background item, the word background lko used to make it clear what I want to achieve, in practice every time the table is updated I would not want the update to be visible to the human eye as shown in the video

[Artik]

I haven't tested, but it seems that you should put:

Please Login or Register  to view this content.

before line:

Please Login or Register  to view this content.

Artik

[GrabberHackman]

after several tests with this string, the table does not perform any updates

[Artik]

Unfortunately, without the sample file, which will reflect the actual file, I can not help.

Artik

[GrabberHackman]

the sample file

[Artik]

The sample file does not have symptoms shown in the video, so it is not representative.
Try to comment out the line at the end of the procedure while testing:

Please Login or Register  to view this content.

Has it helped?

Artik

[AliGW]

@GrabberHackman

Is your forum profile up-to-date? Are you really using the now very old Excel 2007, or is this a release of MS365? If the latter, then please update your profile. Thanks.

[GrabberHackman]

thank you so much @Aligw for making me notice this what i will provide immediately

[josephteh]

If what you mean by not updating is the new data in row 132 not appearing in your PivotTable, that's because your data source only covers the range Elab!$A$2:$B$131.

[AliGW]

It's still 2007. I don't think you understood my question!

Do you have software that is over 15 years old (Excel 2007), or do you have MS Office 365 (release 2007)? If you have the latter, you need MS365 in your profile. If you still have the very old version, you need Excel 2007, please.

[GrabberHackman]

aligw is my excel 2007 version

[GrabberHackman]

what I want to get and not see the changes on the screen

[AliGW]

OK - If you still have the very old Excel 2007, then your profile is fine. Thanks.

[GrabberHackman]

I have modified the result and appreciable, if there are other suggestions, I am happy to accept them
sample file

Please Login or Register  to view this content.

in the original file some changes are still shown on the screen which in my opinion is linked to the parameter in not intersect in the worksheet

video
https://youtu.be/j1TruAcxbpg

[Artik]

Have you tried the advice from post # 6?

Artik

[GrabberHackman]

yes I added
at the beginning of the module

Please Login or Register  to view this content.

while at the end of the form

Please Login or Register  to view this content.

in the attached video, you can see the result in the optimal example file, while in the original file you can still see some changes that in my opinion are related to the intersect

https://youtu.be/j1TruAcxbpg

[Artik]

I asked you to disable the line which enables screen refresh by adding an apostrophe to the beginning of the line:

Please Login or Register  to view this content.

Artik

[GrabberHackman]

sorry i didn't see the font, i try

[Artik]

Have you tried the advice from post # 6?

Oops, it was supposed to be post # 8. I'm sorry too.

Artik

[GrabberHackman]

great it works

[Artik]

Now try turning the commented out line back on, but in a different order:

Please Login or Register  to view this content.

Artik

[GrabberHackman]

good start of the week @artik, I did some tests that I attach you in the video on the selection and deselection of the string Application.ScreenUpdating = True

unfortunately, the result I get in the example file is not the same as what you get in the original file.
I enclose a demonstration video of what I tried

https://youtu.be/XI6jcR29bHA

[Artik]

Do you have the Calculate event programmed somewhere in the original file?
When you turn on automatic recalculation (at the end of the procedure), all formulas that depend on the data range to be changed with the macro will be recalculated. If the Calculate event is programmed, it probably affects the data refreshing.

Artik

[GrabberHackman]

disabale Application.ScreenUpdating = True good work