Help please, I have a spresdsheet I created and use it to attach to other workbooks that has formulas to pull data from other sheets within the newly attached workbook. Problem is that when I open my workbook and copy my worksheet excel then duplicates the page reference and puts the duplicated part in brackets [] then my formulas no longer know what page to pull the info from.
Example; my formula is =(‘Combined Master’!C5) so that this sell can pull the info from C5 of sheet Combined Master. However once I attach this spreadsheet to my workbook excel then re-writes my formula to (‘[Combined Master]Combined Master’!C5) and I then have to go to every cell having to erase the “[Combined Master]”.
Is there some way to stop excel from changing/duplicating the reference page?
