Master Spreadsheet

Hi,

I have a master spreadsheet where I update data on a field "fees".    I have client spreadsheets which link to this master spreadsheet.  I have a problem described below:
If I update the master by inserting or deleting rows or columns, any client spreadsheet that is not open at the time will not get adjusted. As an example, let's say the price I want is in cell C15. If I insert a row above that, then it becomes C16. If the client spreadsheet referencing that cell is open when I insert the row in the master, the client spreadsheet adjusts correctly.   However, it is not practical to have all the client spreadsheets open before making the update.   Is there a way to have a master spreadsheet changed and have spreadsheets that reference it update automatically?

Thank you!