In my quest to find where my hidden links are, I've deleted every single sheet from my workbook (created new blank one), deleted all Defined names, confirmed there are no hidden sheets, etc.
With all this, I'm still seeing a link and my file STILL tried to connect upon opening.
Oddly enough, I couldn't attach the file because it's too big? with literally zero data entered on one black Sheet? How can a spreadsheet have nothing but a single empty sheet and still be 1.9mgs?
Any thoughts? So lost.
Last edited by Blaketus; 05-13-2022 at 11:57 AM.
Hidden sheet(s)?
None that I can find. I've attached file (.zip). I honestly don't understand how this "empty" file can be so large.
could be VERYHIDDENSHEETS
could go to the DEVELOPER Ribbon and then visual basic and check to see if there is a sheet marked as VERYHIDDEN which would only show in VBA.
You can also try searching for the link in your workbook
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Thought of that but can't find any. File (.zip) is now attached.
i dont see a file attached:
You could FIND & SELECT on home ribbon.
Then select GO to special...
select Formulas and leave everything below it checked.
Se if that brings you anywhere
is file extension .xlsx or xls?
@dosydos
file is .xlsm (but there are no macros that I see and the file size remains the same when saved as .xls)
Nothing found in the GO TO special attempt.
and there are no Objects/modules/userforms in visual basic under the project in the properties box?
what about queries and connections maybe to Power query or something?
Are you married to this file? Can you just delete it and create a new file? Probably will be easier in the long run.
Last edited by dosydos; 05-13-2022 at 01:32 PM.
No queries. No connections.
Unfortunately, I AM married to this file. What you see in the attachment is a much larger financial model (real estate) that has had everything I could find systematically deleted in an attempt to located what's going on. The original file is VERY complex and really can't be duplicated. I thought that I could take it apart sheet by sheet and after getting to the end, the link (and related file size) are still present.
unfortunately i can't think of any other ideas, and FYI i don't see any attached files.
last idea:
Maybe check selection pane see if there are hidden objects or comments?
Selection pane says "Picture3" but I don't know what to do with this info!
Not sure why there's no attachment. It shows that I uploaded a ZIP file
i know what your problem is which is causing your file to get enlarged/bloated in size:
I had this error way back in the day, probably in 2013 or so. For some reason excel starts creating and saving ridiculous amounts of custom cell styles.
Try downloading the XLStylesTool from Microsoft store.
If it works like it did back in the day, the program will scrub your selected file of unecessary Named ranges/custom cell styles without touching your actual data. I have not had to use this in a long time and it was on a much older version of Excel but it worked flawlessly.
Last edited by dosydos; 05-13-2022 at 02:26 PM.
That was amazing. Totally took care of everything. No idea how but I'll take it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks