By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes
   dbr983 : -2147217900 The INSERT INTO statement contains the following unknown field name: 'dt_accessed'. Make sure you have typed the name correctly, and try the operation again.insert into listaccess (dt_accessed,list_id,userid,ip_addr) values ('12/2/2021 3:11:39 AM',33461,-1,'34.207.247.69')

listi.net

 


What is Excel #Ref! Error and How to Avoid it

The Excel #Ref! error means there is an unknown reference or address in a cell formula.

There are times where you want to copy and paste cells (ctrl+c) vs. cutting  and paste(ctrl+x). One problem with cutting is that you can create #REF! to an existing formula.

To see this, enter into:
A1 the number 1
A2 =A1+1
Cut A3 and paste to A1
A2 = #REF!

Instead Copy A3 and paste to A1.
blog comments powered by Disqus
   
Home | About | Feedback| Privacy | Terms of Service | @alecberg | FAQ | | Copyright © 2021 All Rights Reserved. Edit
This site uses cookies. If you don't want cookies and who doesn't want them as they're yummy, then leave.