Updating excel files

Posted by / 25-Oct-2016 00:05

I thought I’d therefore share the process I use so anyone who has the same struggles as me can get a potential solution from one location.This works for me, but of course may not work for you depending on the setup you have, so mileage may vary. Part 2 of this topic is available here : Automated updating of BW data in Excel files (BEX & AO) via VBA/VBscript – Part 2 Part 3 of this topic is available here : Analysis for Office Variables and Filters via VBA Part 4 of this topic is available here : Analysis for Office and Excel VBA – Lessons learnt This guide covers : We have a number of excel files that we wanted to have updated on a regular basis without users having to load the files, log in/connect to BW and then refresh.Then when the numbers change next week or month, the Power Point slide can automatically update. Except every great idea does have potential downsides you need to know about.Here’s what you need to consider before deciding to link a table or graph from Excel to Power Point: If you still want to link the cells from Excel to the slide in Power Point, scroll down to see how to do it.

Because it is a Power Point object, it will be consistent with the organization branding standards.

This could be major overkill, especially since the user could have several unrelated, potentially complicated, workbooks open.

I'm pretty sure this is not the same thing as Application.

He told me the model did not update, so I checked it out.

The cell references were all correct, but for whatever reason they would not update.

updating excel files-22updating excel files-84updating excel files-17

So I can not do a find and replace in the formulas as there are too many cells.