Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel for Mac > RE: Two Serious...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 317 of 349
Post > Topic >>

RE: Two Serious problems

by =?Utf-8?B?Ry5SLg==?= <GR@[EMAIL PROTECTED] > Apr 12, 2008 at 03:01 PM

Sergio -
Regarding your first problem: 
I'm a new Excel user but had a similar problem with my Mac.  After
im****ting 
data from multiple text do***ents to make a worksheet, the computer would 
slow way down. What solved the problem for me was deleting all the named 
ranges Excel had created when I im****ted the text.  Click on Insert - Name

and choose Define. In the Define Name window you will see the named ranges
in 
your worksheet. You can click on one and hit delete. I had so many that I 
found the following macro to delete all of them for me:

Sub NLFI_Delete_Range_Names()
'
' Delete all range names
'
Dim NameX As Name
For Each NameX In Names
ActiveWorkbook.Names(NameX.Name).Delete
Next NameX
End Sub

Hope this helps, or somone smarter posts a better answer.
 




 3 Posts in Topic:
Two Serious problems
"Sergio Gi.Ma.G.&quo  2008-03-29 20:51:13 
Re: Two Serious problems
"Shane Devenshire&qu  2008-04-12 15:00:39 
RE: Two Serious problems
=?Utf-8?B?Ry5SLg==?= <  2008-04-12 15:01:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Dec 4 22:42:22 CST 2008.