Author Topic: Excel 2013 Challenge  (Read 82 times)

0 Members and 1 Guest are viewing this topic.

Online Billy Welsh

  • Scalliwag
  • ******
  • Posts: 3050
  • Karma: +462/-5
  • Who's scruffy looking?
Excel 2013 Challenge
« on: October 08, 2019, 12:45:02 pm »
At some point my illustrious contract employee decided he did not like what I was doing with MY file, and he did something (does not recall what) to kill an open window.


So not when I open the file, I get the attached showing there are 3 open windows.  However, #1 is nowhere to be found other than on this drop-down.  You can switch to it with the drop-down, but nothing is there.  It does NOT show up in the taskbar.


I have tried every Unhide I can find, and a few other solutions per Googling.  No luck.  Not mission critical, just annoying.


Anyone else ever seen this?
Accounting
Uniti Fiber

Offline FWA

  • Scalliwag
  • ******
  • Posts: 2820
  • Karma: +293/-1
Re: Excel 2013 Challenge
« Reply #1 on: October 08, 2019, 04:47:38 pm »
Looks like something I (would) do.

You have researched "deeply hidden", "very hidden" and things like that on the internet?  Dove into the developer settings?

Do you have AsapUtilities?  It is money well spent and may be able to unhide.
Fantasy is more important than knowledge, because knowledge has its boundaries - Albert Einstein

Another day, another clay.  All that matters is the next bird.

Offline Jeff Golas

  • Administrator
  • Scalliwag
  • *****
  • Posts: 3028
  • Karma: +345/-0
    • JKJ Website
Re: Excel 2013 Challenge
« Reply #2 on: October 08, 2019, 05:54:15 pm »
Look at the macros on the file, the windows may not be there but processing something instead.
Jeff Golas
Johnson, Kendall & Johnson, Inc. :: Newtown, PA
Epic Online w/CSR24
http://www.jkj.com

Online Billy Welsh

  • Scalliwag
  • ******
  • Posts: 3050
  • Karma: +462/-5
  • Who's scruffy looking?
Re: Excel 2013 Challenge
« Reply #3 on: October 08, 2019, 06:50:38 pm »
No macros in the file.  It does have Pivot Tables.


I have searched many combinations of hidden windows, but I have not tried Hans' creative variations.  Hidden is hidden I would think when Googling.  I have not looked at Developer angle - that's usually out of my league.
Accounting
Uniti Fiber

Offline Mark

  • ScurvyDawg
  • *******
  • Posts: 7261
  • Karma: +613/-7
  • meh.
    • Mark Piontek
Mark Piontek, MBA
Director of IT
BS in Information Systems Security
MarkPiontek.com

Online Billy Welsh

  • Scalliwag
  • ******
  • Posts: 3050
  • Karma: +462/-5
  • Who's scruffy looking?
Re: Excel 2013 Challenge
« Reply #5 on: October 09, 2019, 12:40:56 pm »
I have previously tried that, no joy.


I wanted to repeat that this morning just to double-check, but my PC is choking resource-wise right now, and I can't yet get to a point of restarting it.
Accounting
Uniti Fiber

Offline Mark

  • ScurvyDawg
  • *******
  • Posts: 7261
  • Karma: +613/-7
  • meh.
    • Mark Piontek
Re: Excel 2013 Challenge
« Reply #6 on: October 09, 2019, 01:31:28 pm »
I'd also be interested to see if task manager shows three instances of Excel.exe running while this file is open.
Mark Piontek, MBA
Director of IT
BS in Information Systems Security
MarkPiontek.com

Online Billy Welsh

  • Scalliwag
  • ******
  • Posts: 3050
  • Karma: +462/-5
  • Who's scruffy looking?
Re: Excel 2013 Challenge
« Reply #7 on: October 09, 2019, 01:39:57 pm »
Generally it does not.  When I reboot, I can prove it.  I am accomplishing this by opening a new window (View, New Window), not by opening the file 2x or 3x.
Accounting
Uniti Fiber

Offline Jeff Zylstra

  • ScurvyDawg
  • *******
  • Posts: 5150
  • Karma: +566/-2
Re: Excel 2013 Challenge
« Reply #8 on: October 09, 2019, 02:57:54 pm »
This may sound ultra-stupid, but have you tried creating a new file, and copying and pasting the contents to the new file?  Or maybe even running a repair on the file?  It sounds like the file may actually be corrupted, and/or there is hidden "code" or commands in that file.  Just a thought.
"We hang the petty thieves, and appoint the great ones to public office"  -  Aesop

Online Billy Welsh

  • Scalliwag
  • ******
  • Posts: 3050
  • Karma: +462/-5
  • Who's scruffy looking?
Re: Excel 2013 Challenge
« Reply #9 on: October 10, 2019, 01:04:20 pm »
That's more work than I'm willing to do for a mere annoyance  :o


Lots of data and pivot tables on multiple sheets.  I still have my 2 windows to work in; I just have to work in 2 & 3 and remember that #1 is a phantom.
Accounting
Uniti Fiber