I have three questions about linking to Excel data in Power Point 2013.
1. Is there a way to have a text field that has text as well as dynamic data? What I'm doing is making a slide with the sentence "This project has another $900 in expenses in 2017." I would like the "900" to be dynamic. I already did that by making text that says "This project has another [blank space here] in expenses in 2017." Then I made a link to the cell with the "900" and put it over top of that text box in the right place. That works, but it's not very pretty, if the value changes to 1,000 then the spacing looks funny. Is there a different way to do this?
2. One of my slides has a linked Excel value, and in the Excel sheet that cell is a total so it has border formatting on the top and bottom. Is there a way to keep it as a linked cell, but not carry over the formatting? I don't want those lines to show up in Power Point. In Power Point, the border formatting is already set to have no lines.
3. My Power Point slide has a link to Cell E10 on Sheet3, and updates dynamically as it should. The problem is, if I insert a row into sheet 3, then the value I need moves down to cell E11, but Power Point still looks at E10. Is there a way to link Power Point to a value dynamically? ie, could it do something like VLOOKUP("Total",Sheet3!A:E,5,0)
Thanks so much, I've spent a few hours googling this to get as far as I've come, but I just can't get past these 3 things.