I am trying to create a formula in a master workbook that will link data from
several different users who all have their own saved version to which they
will be adding data to on a daily/weekly basis. When I begin to write my
formula in the master file and open the next spreadsheet, excel is
automatically converting the user's worksheet back to the master document.
Any ideas or suggestions?