 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / January 2008Paste Special Help (Excel 2003)
Hi, Strange thing has started with Paste Special from one workbook to another although in the same workbook the function is fine; When I copy from one workbook, go to the other and select Paste Special the new window pop up is strange and shows a list to select from as follows; MS Office Excel Object Picture (Enhanced Metafile) Bitmap MS Excel 8 format Biff5 Biff4 Biff3 Biff SYLK WK1 DIF XML Spreadsheet HTML Unicode Text Text CSV Hyperlink Any ideas much welcomed. Regards Newbeetle  SignatureThis post was created using recycled electrons! It would help if you could explain what you are trying to paste. Thx, JP On Jan 31, 12:36 pm, Newbeetle <Newbee...@discussions.microsoft.com> wrote: > Hi, Strange thing has started with Paste Special from one workbook to another > although in the same workbook the function is fine; [quoted text clipped - 25 lines] > -- > This post was created using recycled electrons! Make sure you have both workbook files open in the same instance of excel. Close one workbook (and that instance of excel) and use File|open to open the second file. Then try it. > Hi, Strange thing has started with Paste Special from one workbook to another > although in the same workbook the function is fine; [quoted text clipped - 25 lines] > -- > This post was created using recycled electrons! SignatureDave Peterson Thanks Dave, Works a treat, funny I don't recall opening the sheets that way before , so I guess memory loss is settling in as I do this monthly oh well. SignatureThis post was created using recycled electrons! > Make sure you have both workbook files open in the same instance of excel. > [quoted text clipped - 32 lines] > > -- > > This post was created using recycled electrons! You may have checkmarked Tools>Options>Generl "Ignore other application" which would cause you to open a distinct instance of Excel for each file opened by double-click. Tools>Options>General Uncheck "Ignore Other Applications" If no joy with that................ Close Excel first and On the Windows Taskbar 1) Start>Run "excel.exe /unregserver"(no quotes)>OK. 2) Start>Run "excel.exe /regserver"(no quotes)>OK. See the space between exe and /regserver You might have to designate a full path to excel.exe. In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes required)>OK. Gord Dibben MS Excel MVP >Thanks Dave, > >Works a treat, funny I don't recall opening the sheets that way before , so >I guess memory loss is settling in as I do this monthly oh well. Cheers Gord, It always great this site for fast response, glad you guys are out there! I tried your idea but have the same problem, but no probs at least I have a solution and can sleep tonight. Thanks to everyone for your help as always. SignatureThis post was created using recycled electrons! > You may have checkmarked Tools>Options>Generl "Ignore other application" which > would cause you to open a distinct instance of Excel for each file opened by [quoted text clipped - 21 lines] > >Works a treat, funny I don't recall opening the sheets that way before , so > >I guess memory loss is settling in as I do this monthly oh well. |
Reply to this Message |
 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.