We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Excel:  How to stop losing my formulas when refreshing CMS download

Medium Priority
185 Views
Last Modified: 2012-05-11
Experts,

I have a spreadsheet that contains several Vlookups.  When I import the new data into the spreadsheet all my formulas turn in "#REF".  Is there a way around this?

Thanks
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Sid:
  When I import the data regardless of the $ signs being placed it returns a
=VLOOKUP($D$2,'NOC Agent Daily S'!#REF!,15,0)
after my import.

Hmm

Author

Commented:
The only thing I suppose I could do is write a script that will but in the formulas by VBA.
Ok, Can you upload a workbook which has data imported in it and it is giving you an error?

Sid

Author

Commented:
I can wite the VBA script so that is okay.  I was just hoping there was another way.
If I look at your file then maybe I can suggest you another way?

Sid

Author

Commented:
Okay so I went with find and replace after I imported the info. Puts back the formula.  

Thanks for your help!

Author

Commented:
The $ does help in other applications, though
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.