Update workbooks

I have a sheet that I am calculating food macros. I have all of my calculations done. One of my columns is the amount of food allowed. I have another area where I enter the calories allowed.

I want to be able to change the calorie intake and have all of my "amount of food allowed" automatically update for me. When an Excel data point reaches a certain value I would like that value to be "texted" or "SMS" to my cell phone provider so I can recieve the message. The spreadsheet is automatically connected to another data source and updates automatically every second. How can I do this?

I need help creating an excel sheet that takes information from one column in another sheet to automatically update the corresponding row or information in the master sheet. This comment form is under antispam protection. Most reacted comment. Hottest comment thread. Recent comment authors. Sudha kumari. Subscribe to Excelchat. Did this post not answer your question? Get a solution from connecting with the expert.

Try for free. Trusted by people who work at. To find out more, see here: Cookie Policy. Ok, Got It! Got it! The 8 other workbooks read the year from the master workbook and then change their data which in turn feeds back to the master.

Unfortunately, I can only get the data to update real-time in the the master workbook if I have all 8 other workbooks open. Is there a way to change this so that I do not have to open each individual linked workbook? I'm working in Excel with Windows 7 Professional. Any tips or advice would be appreciated! This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software.

This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No.