(C) 2009 - 2018 by Mourad Louha · All rights reserved

All posts tagged Dynamic

This following post is a guest post and was written by Roberto Mensa, Krisztina Szabó and Gábor Madács. Thanks Roberto, Krisztina and Gábor 🙂

A few days ago we were working with the CELL formula to draw your attention to use the English info_type attribute if you share your Excel file with someone how uses Excel with different language setting. The second argument of this formula is the reference, which is optional. If it is omitted, the information is returned for the last cell that was changed, as we can read in the Excel Help.

Dynamic Chart in Excel

It is important to make it clear that “last cell that was changed” relates to the calculation. Change means a kind of change that triggers calculation. So if you manually re-calculate your sheet, the “last cell” will be the active cell where your cursor is positioned. My Hungarian friend Krisztina Szabó gave me an idea to build a dynamic chart based on the active cell. So we made a challenging example. In this article, we would like to show you how you can build up a similar solution based on our tricks. We have provided a sample file, which you can download at the end of this article.

Read more

A user asked in my favorite German forum “Office Lösung” about MS Office, if it is possible to automatically update an image from a web server in Excel. The user also posted some sample links and wished that the update should occur every minute.

The images from the web server are sent to the browser as raw data and therefore no HTML code is used. By the way, this can be for example achieved in PHP by calling the functions “header()” and “readfile()” in a specific order and setting the arguments to appropriate values. Unfortunately, we cannot use an Excel web query for linking to the image as the query will return unusable data. So, another solution must be found in this case.

Excel Dynamic Image

Read more