Guido, It appears in my version of 2013 Excel our network IT is not giving me the ability to add-on PQ. I looked through all the options but I did add PowerPivot. After all of this I will work on learning more about pivot tables and using external data as suggested. I'll look for the A1-ref...
Thank You Guido and Peter.
I tried the VBA code and was not successful. I kept running into the debugger. I'm not versed with VBA and it should be something I should learn next. However I used your Replace suggestions to change the cells to text with taking the = sign out and changing the cell...
Hi. Thank you for the tips. I found no Locations where connections are. I did go through the name manager and deleted locations other than in the existing workbook. Though, in the Connections>Edit Links I was able to change the source with most of the rows but somehow I lost the cell...
Hi, I have a rather large worksheet for Chart Data that is for different charts within the workbook but the cell references are pointing to another workbook. I want to replicate the charts and chart data from fiscal year (FY18) to fiscal year (FY19) and also change the months date to 2018 and...