I've downloaded and have used and posted the mini sheet on previous posts and it worked fine. Now, when I try to copy the selected cells into the mini sheet, it keeps "not responding" and i have to close it out of Excel and restart. I've checked the settings and, as far as I can tell, nothing is blocked. I also tried reducing the number of cells thinking it might be too much data but I can't even copy a single cell without it not responding. And I tried limiting the additional info to just cell formulas and name ranges, to no avail. I can do the "table only" and that works, just not the mini sheet. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Mini Sheet Xl2bb crash/not responding
- Thread starter kckliodna
- Start date
I think I got it, the named ranges is making it not respond. When I unchecked that box, it worked. Any reason it's doing this in case I need to include that info?
I do, but I"ve been able to do it before with this same worksheet.
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,207
- Office Version
- 365
- Platform
- Windows
- Mobile
Check if the problem in link below is your issue
www.mrexcel.com
Please make xl2bb check for infinite ranges
I am trying to use xl2bb as much as I can. It clearly makes submitting and understanding questions much easier for everyone. But it has also caused me a lot of extra work and frustration. This is because it hangs if there are any "infinite" named ranges ($3:$3 or $B:$B) defined anywhere in the...
