Thousands of named ranges

[billryan13]

We need help!! We use a shared financial workbook that is saved on Sharepoint. The workbook is completely gummed up with thousands of named ranges - as many as 188K - and most are hidden. We run macros to unhide them and delete - but they keep coming back. I just downloaded the list from our current book (+50k). Does anyone know where they are coming from and how to make it stop? It causes Excel to grind to a hault and we stare at the swirly all day. Some appear to be written in chinese!! A few excerpts below...

_xlcn.LinkedTable_ADA_Code_Lookup​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!ADA_Code_Lookup[#Data]​
_xlcn.LinkedTable_AdjustmentType​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!AdjustmentType[#Data]​
_xlcn.LinkedTable_CapitationIndicator​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!CapitationIndicator[#Data]​
_xlcn.LinkedTable_InvisalignIndicator​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!InvisalignIndicator[#Data]​
_xlcn.LinkedTable_MetrocareID​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!MetrocareID[#Data]​
_xlcn.LinkedTable_MetrocareIndicator​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!MetrocareIndicator[#Data]​
_xlcn.LinkedTable_OfficeLookup​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!OfficeLookup[#Data]​
_xlcn.LinkedTable_Ortho_PatientLookup​	='https://luminatecapital.sharepoint.com/Users/jfleurinor/Desktop/Gentle Dental/December Close/Uploaded Models/Uploaded to Gentle 03242016/Gentle Dental -- December 2015 Revenue Model V4 for Reports.xlsb'!Ortho_PatientLookup[#Data]​
_xlcn.LinkedTable_OrthoIndicator​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!OrthoIndicator[#Data]​
_xlcn.LinkedTable_OrthoStartDates​	='https://luminatecapital.sharepoint.com/Users/skunkle/Documents/1. Projects/5. Project Outlaw/2. Dec15 Deca Model/Deca Dental -- 2015.12 Revenue Model 02.04.2016 1000.xlsb'!OrthoStartDates[#Data]​

ㅂㅁ​	={#N/A,"PURCHM",FALSE,"Business Analysis";#N/A,"SPADD",FALSE,"Business Analysis"}​
ㅂㅂ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅅ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
손익3​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
수​	={#N/A,#N/A,TRUE,"Basic";#N/A,#N/A,TRUE,"EXT-TABLE";#N/A,#N/A,TRUE,"STEEL";#N/A,#N/A,TRUE,"INT-Table";#N/A,#N/A,TRUE,"STEEL";#N/A,#N/A,TRUE,"Door"}​
ㅇㄴㄹㄴㅇ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
이​	={"vol data",#N/A,FALSE,"Datasheet";"vol graph",#N/A,FALSE,"Volume";"price data",#N/A,FALSE,"Datasheet";"price graph",#N/A,FALSE,"Price";"dp data",#N/A,FALSE,"Datasheet";"dp graph",#N/A,FALSE,"DirectProfit"}​
ㅈㄷㄱ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅈㄷㄱㅈ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅈㄷㄱㅈㄷ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅈㄷㅇ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅈㅈㄷ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
차량SVC​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅎ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅏㅣㅑ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
ㅕㅏㅏㅣ​	={#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"UNIT";#N/A,#N/A,FALSE,"계정"}​
一括​	={"DCF-北海道",#N/A,TRUE,"北海道";"DCF-東北",#N/A,TRUE,"東北";"DCF-東海",#N/A,TRUE,"東海";"DCF-北陸",#N/A,TRUE,"北陸";"DCF-関西",#N/A,TRUE,"関西";"DCF-中国",#N/A,TRUE,"中国";"DCF-四国",#N/A,TRUE,"四国";"DCF-九州",#N/A,TRUE,"九州";"DCF-連結",#N/A,TRUE,"連結"}​
印刷​	={"DCF-北海道",#N/A,TRUE,"北海道";"DCF-東北",#N/A,TRUE,"東北";"DCF-東海",#N/A,TRUE,"東海";"DCF-北陸",#N/A,TRUE,"北陸";"DCF-関西",#N/A,TRUE,"関西";"DCF-中国",#N/A,TRUE,"中国";"DCF-四国",#N/A,TRUE,"四国";"DCF-九州",#N/A,TRUE,"九州";"DCF-連結",#N/A,TRUE,"連結"}​
年間収支買掛​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​
年間資金収支あ​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​
日繰06​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​
焑贠焈​	="c1307"​
系統出資金​	={"DCF-北海道",#N/A,TRUE,"北海道";"DCF-東北",#N/A,TRUE,"東北";"DCF-東海",#N/A,TRUE,"東海";"DCF-北陸",#N/A,TRUE,"北陸";"DCF-関西",#N/A,TRUE,"関西";"DCF-中国",#N/A,TRUE,"中国";"DCF-四国",#N/A,TRUE,"四国";"DCF-九州",#N/A,TRUE,"九州";"DCF-連結",#N/A,TRUE,"連結"}​
系統外出資金​	={"DCF-北海道",#N/A,TRUE,"北海道";"DCF-東北",#N/A,TRUE,"東北";"DCF-東海",#N/A,TRUE,"東海";"DCF-北陸",#N/A,TRUE,"北陸";"DCF-関西",#N/A,TRUE,"関西";"DCF-中国",#N/A,TRUE,"中国";"DCF-四国",#N/A,TRUE,"四国";"DCF-九州",#N/A,TRUE,"九州";"DCF-連結",#N/A,TRUE,"連結"}​
要処理資産②​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​
評価対象​	='\\Toei2000\共有フォルダ\Documents and Settings\s-koike\デスクトップ\[新TAX.xls]計算過程シート'!#REF!​
資金​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​
金利体系​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​
関連​	={"'下期集計（10.27迄・速報値）'!$Q$16"}​

 

[Coding4Fun]

It sounds like something with the file specifically, perhaps an issue with a sync with sharepoint. The link appears to be pointing to a specific users documents library. I know sometimes links get broken.
Not sure how you are deleting the named ranges. Have you tried to delete them and save a copy as a new workbook?

This link may be of assistance

Issue deleting named ranges

I have many excel files that have bad hidden named ranges (old files I'm trying to clean up for folks). I have tried all of the 'delete range names' suggestions, but I still keep running across a named range called "=#NAME?" - and so the code bombs at this point and nothing is deleted. the...

www.mrexcel.com

Or perhaps this one, it refers to a method of editing the Excel XML source file to remove the named ranges.
Note I cant speak to the product on this site, just referring to the article regarding editing the excel file to remove the ranges.
Link2

 

[billryan13]

The sharepoint references are not our company and we have no idea who its from. We delete them using a macro to unhide and then Name Manager to delete....and they seem to come right back.

 

[JonStanley]

I have had this problem consistently for years to the point where I have given up on being able to use the name manager. It seems like this pops up for me most consistently when I am querying from a SharePoint list or document library with power query. Has anyone found a cause or permanent fix for this?