Forum Discussion

Zac_Chen2020

Copper Contributor

Jun 28, 2020

Solved

Showing gray bar when opening the excel and lags when scrolling the window

Hi: My excel version is Office 365 Proplus, 1902 version. I use some macros in these charts but the total file size is about 800k. I encounter 2 issues and it seriously affect the working efficie...

Macros and VBA

ExcelExciting
Jun 29, 2020
Hi Zac_Chen2020;

Point 01
You need to debug you code and see what is making this mess & slight alter the code accordingly. What I can understand it is not finding the range of the data source.. It will be difficult to comment until not debug and see the code.

Point 02
You need to adjust the chart settings by selecting the chart & right click you see the format chart area > select "Don't move or size with cells"

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

ExcelExciting

MVP

Jun 29, 2020

Hi Zac_Chen2020;

Point 01

You need to debug you code and see what is making this mess & slight alter the code accordingly. What I can understand it is not finding the range of the data source.. It will be difficult to comment until not debug and see the code.

Point 02

You need to adjust the chart settings by selecting the chart & right click you see the format chart area > select "Don't move or size with cells"

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more