• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Find & Replace within a formula that has an absolute reference

    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...
  2. D

    Find & Replace within a formula that has an absolute reference

    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...
  3. D

    Find & Replace within a formula that has an absolute reference

    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...
  4. D

    Find & Replace within a formula that has an absolute reference

    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...
Back
Top