I get the attached '_Fill' error when I attempt to copy one of my worksheets. It does allow me to rename it (whatever "it" is) but I'd really like to determine the reason for this error and eliminate it if possible (I'm going to be making a lot of copies of this sheet).
I cannot find a formula or named range that contains "_Fill" so I have no idea what it it is referring to.
Anybody point me in the direction of what is causing this?
Thanks!
Chris
Last edited by costgeek; 04-11-2018 at 08:32 AM.
If you want us to have a stab at finding it, attach the workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Normally I would...but can't do it with this spreadsheet
Why is that? Can't you desensitise the data?
Frankly, the error message you are getting is really clear - you just need to find that reference. If you can't attach the workbook, we can't help.
Presumably you have looked in the Named Ranges dialog on the destination sheet? If not, do so. Beyond that, I'm not able to say.
The name could be hidden, in which case you can download the Name Manager add-in from here to find it- http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp
Don
Please remember to mark your thread 'Solved' when appropriate.
It's a little more complicated than just desensitising the data.
I've done everything I can think of to locate the reference...I can't find anything that contains "_Fill". I was hoping someone would recognise it...it's something Excel is generating its own.
Thanks anayway.
Yeah...I've gone through every line in the Name Manager...it's not in there.
The built-in Name Manager doesn't show hidden names, which is why I suggested that one.
Are there any charts or graphs?
If it were me, I'd be at least trying to provide a sample file that illustrates the issue and attaching it here. Otherwise, it's just guesswork. However, I did just Google it and came up with:
https://www.pcreview.co.uk/threads/_...-copy.3992688/
and:
http://www.44342.com/MS-EXCEL-f81-t150825-p1.htm
what happens if you just say yes? (make sure to test on a copy first)
I have this error sometimes with named ranges I created myself. It never seem to hurt me if I just say yes. The only "confusing" part can be that in the name manager you can have 2 same names refering to different ranges. but as long as the names are not used in VBA to call on the named ranges. I never had a problem with duplicate names.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks