Forum Discussion
Formula copy error, when not copying formula
It seems highly unlikely that the error message itself is in error. (That checking for circular references has been around for longer than you and I have been alive (a slight exaggeration, perhaps, but you get the point).
If it doesn't violate confidentiality, would it be possible for you to post a copy of the file in question, either on OneDrive or GoogleDrive?
- I'll see if I can get some sanitized versions, but the thing I forgot to mention in the original post is that is seems to be only affecting the 1 user, if someone else tries the same files it does not happen
TimPoulter wrote
the thing I forgot to mention in the original post is that is seems to be only affecting the 1 user, if someone else tries the same files it does not happen
And that omission is key to diagnosing what's happening. No need to post the file. Go find out what that one user is doing distinctively, uniquely.
mathetes nothing out of the ordinary, they are job/po numbers and a price/cost from an excel sheet from the vendor, copy to a job tracking sheet that they use internally
JoeUser2004thats the thing though. there is no formulas/formula results in the cells that are being copied so there should be no need to calculate anything. Its just a simple value
