Updating excel sheet
Lets say i have an excel sheet("daily report") opened in one book("Book1") and another("monthly report") opened in another book("Book2").
How can i make the "monthly report" to get updated dynamically while working in "daily report".
Thanks for your help, Chris I think it can be done but depending on how many workbooks there are this could be a lenghty process and the next time it will need to be done again.
If changes are going to occur every so often I would recommend putting the macros in an external workbook which you open up in hidden mode whenever your main workbooks are opened.
Excel Locale1033Proxy class from Excel projects that are retargeted to the . Visual Studio doesn’t remove this attribute or the class reference for you.
Projects that were created by using Microsoft Visual Studio 2005 Tools for the Microsoft Office System instantiate the Excel Microsoft.
When I change the input of a formula, the output is not automatically updated. How do I get Excel to update formulas automatically again?I've had the same issue since we recently "upgraded" to Office 2013.I have formulas linking to other tabs in the same workbook.Some of them are not even formulas - they just "=" the number from the other tab. I've found that if you click in the formula bar when in the source cell, and hit enter, it refreshes the cell which is linked to it. To do this on a grand scale, I do a Find "=" & Replace with "=" for the whole workbook.
It will depends on the type of info to be updated from book1 to book2 I mean it will be easily to do this in book2 =SUM([' Book1.xls]daily report'!