Im having an issue trying to get forulas and just the formulas to paste properly EX:=SUM('# Install Pending'!R5, '# Install Complete'!R5)-32, turning into =SUM('[Copy of DNR SALES LOG.xlsx]# Install Pending'!R5, '[Copy of DNR SALES LOG.xlsx]# Install Complete'!R5)-32. Its keeping the original workbooks title altering where the info is being grabbed from. I am currently using a copy of the reports to make changes to them but when I bring the changes over the whole formula gets altered to keep the same refernece point rather than alter to grab the information from the current workbook it is in.
And I would rather not go through over 300 cells taking out those [Copy of DNR SAles Log.xlsx] on every one
Any Idea i have tried turning off auto update formulas, as well as special copy and paste but it isnt allowing me to copy just that formula as it sits in the current cell.