 |
 | 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 / Worksheet Functions / February 2008Copy worksheet without linking
Is it possible to copy a worksheet from one workbook to another workbook without creating a link? If you are trying to move the whole sheet... Right click on the sheet name... click the box that says Create a Copy Then select the Workbook you want to copy and paste that sheet too If you want to copy and paste data with out linking... just copy the worksheet info and paste special values to the new worksheet. > Is it possible to copy a worksheet from one workbook to another workbook > without creating a link? I have done that for the worksheet and when it is reopened you are asked if you want to update links. There is nothing in the worksheet that should update. Is there a place to change "automatic" linking? > If you are trying to move the whole sheet... > [quoted text clipped - 7 lines] > > Is it possible to copy a worksheet from one workbook to another workbook > > without creating a link? Hi! select the upper left cell (above the numbers and to the left of the letters) this will highlight the worksheet. select copy from the toolbar go to new worksheet again select the upper left cell select paste from the toolbar Hope this helps! rsjaag- - paying it forward as someone was kind enough to answer my question today. > Is it possible to copy a worksheet from one workbook to another workbook > without creating a link? Thanks, but the worksheets that they are using are heavily formatted. I have done it on my computer (different workbooks) and I don't get the same linking of sheets. > Hi! > select the upper left cell (above the numbers and to the left of the [quoted text clipped - 13 lines] > > Is it possible to copy a worksheet from one workbook to another workbook > > without creating a link? Depending on the version of excel... Edit|Links|startup prompt button And choose the option you want. (I _think_ that this was added in xl2002, but not positive.) > Is it possible to copy a worksheet from one workbook to another workbook > without creating a link?  SignatureDave Peterson |
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.