I have a file which monitors over 100 files and also produces a graph to help me establish were we are at as a business. I have one problem though this graph only shows data open until the closeworkbook. If the workbook is open and in use the data shown for that workbook is from the previos save&close position. How can i get the graph to update with uptode values even if the workbook is in use.

Does this make sense ?