Hey Guys,.
Not sure where to post this. Google didn't help.
A while back, one of my users f
Printable View
Hey Guys,.
Not sure where to post this. Google didn't help.
A while back, one of my users f
Actually it's very simple.
Just f
It's almost like the phone call just disconnected in mid sentence.
the answer is 42
The other day the phone rang and so I answered it and t
hrmmhhh.. No idea what happened to the Original Post. I typed the whole thing. odd
anyway, She messed up a very large departmental spreadsheet so a couple hundred hyperlinks were re-directed to her local data folder rather than the network share. I fixed it by creating a custom macro (several times) to restore the broken links. I had to do this for numerous file paths.
Ever since I did this, my Excel on my laptop is messed up. Whenever I open any spreadsheet, a second workbook, name "Personal", opens up. I think this "personal" book is the original macro or something. I've tried everything I can think of and tinker with to stop this behavior to no avail. I am not overly skilled in Excel and am kinda hoping one of you can shed some light on this issue. Google was no help.
Thanks
Close Excel, kill any running process.
Look for .xlb and .xlt files under your profile.
Back them up for safety and delete them.
no luck. thanks for trying
Also look for .xltx, .xltm
Those are the templates.
Also go to permissions and stop macros running, look for my templates and check for the path - you might have the wrong path now.