I have inadvertently created a link between spreadsheets.
How in god's name do you get rid of this?
There is a horribly mis-named feature called 'break link' which does NOTHING other than waste our time.
Is there some other method someone could let me know about?
Thanks!!!
the link is probably hidden somewhere else in the sheet.
check the named ranges, the conditional formatting and the data validation and pivot table sources.
You could also upload a sheet and we could find it (obviously stripping out all the formula and data for your privacy).
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Insert this code into the VBA editor and run the macro
Does that work for you?
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks