Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2007

Tip: Looking for answers? Try searching our database.

File Not Found

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leslie Coover - 25 Mar 2007 07:18 GMT
When I send copies of a few worksheets from an Excel file
that contains many other worksheets to a new file I get a
File Not Found when I try to open the new file how can
I get rid of the anoyance?
Nick Hodge - 25 Mar 2007 09:11 GMT
Leslie

I am wondering if you are running into a codename issue with a lot of
worksheet copying.  Normally this is hidden from the user.

Open the workbook and then the VBE by pressing Alt+F11

On the left you should see the project explorer and the properties window.
In the project explorer take a look at the sheet names. One name is the
sheet tab name.  The other name is the worksheet code name and cannot be
change from the user interface.  Are any of these looking like
Sheet111111111111111111?

If so then you need to select that sheet and in the properties window change
the 'Name' property

These, in early versions of Excel grew as sheets were copied, I believe this
was fixed by service pack in Excel 2000, but you may not have loaded this

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> When I send copies of a few worksheets from an Excel file
> that contains many other worksheets to a new file I get a
> File Not Found when I try to open the new file how can
> I get rid of the anoyance?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.