Use the mouse or keyboard to drill down to inputs and back up to your formula in an instant. You can turn it on by default or simply apply it to a specific selection.function reduces the size and optimizes the time of re-calculation of the file. Sheet1 = Data Table & Chart Sheet2 = Data Table & Chart Sheet3 = Data Table Sheet4 = Data Table (3 set) to be placed in the same presentation slide. I will amend it based on my requirement later on ' this goes at This Workbook module Private Sub Workbook_Before Close(Cancel As Boolean) Set ap = Nothing Set newpp = Nothing End Sub Private Sub Workbook_Open() Dim h%, w%, cr#, s3 As Power Point. Visible = True addslide "Sheet2" Updater End Sub Public Sub addslide(By Val ts$) Dim acts As Power Point. https://com/s/zk69nlfk1lryixvwmmnn I have created a sample of 2 worksheets with data table & chart and another 2 worksheet with only data table. Make sure they have the minimum amount of rows and columns. When I copy paste excel table to Power point, Which one I need to choose? At the VBE, right-click This Workbook at the left pane, click show code and paste on the right pane. 2) It would be better that you created the tables directly at Power Point, at Ribbon Table. Range("a2:b20")) Is Nothing Then n = CInt(Right(Sh. Name Like "Sheet" Then Exit Sub If Not Intersect(Target, Sh.
Up Slide can automate this task by generating a presentation directly from an Excel file.
Paste Special pp Paste Default Worksheets("Sheet2").
At the VBE, right-click This Workbook at the left pane, click show code and paste on the right pane.
Get rid of your old Excel template for Waterfall creation.
You can now insert a Waterfall chart as you would insert a bar chart, in one click.