Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Worksheets From One File to Another
Hello All,
I am attempting to move worksheets (which contain formulas) from one file (we'll call it File #1) to another (File #2 obviously), and unfortunately, the result in File #2 is something that reads ='File #1'A6 (just an example). How can I move worksheets from one file to another without including the references to the original spreadsheet? In short, how can I get the cell to read =A6 after it has been moved to the new document? I would truly appreciate any help anyone would be willing to offer. Thanks so much, and have a great day! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Worksheets From One File to Another
If your formulas on the original worksheet point to other sheets in the original
workbook, then those formulas will continue to point to that original workbook after you move it. You have at least a couple of work-arounds. #1. Do the move and correct the formulas (a bunch??) of edit|Replaces to remove the old workbook and old worksheet's name. #2. Use Edit|Links|Change Source (xl2003 menus) to point to the new workbook (you'll have to save this new workbook first, though). #3. Change all the formulas on the original sheet to strings: Select all the cells edit|replace what: = (equal sign) with: $$$$$= replace all Move the sheet And change all the strings back to formulas: Select all the cells edit|replace what: $$$$$= with: = replace all dcapps wrote: Hello All, I am attempting to move worksheets (which contain formulas) from one file (we'll call it File #1) to another (File #2 obviously), and unfortunately, the result in File #2 is something that reads ='File #1'A6 (just an example). How can I move worksheets from one file to another without including the references to the original spreadsheet? In short, how can I get the cell to read =A6 after it has been moved to the new document? I would truly appreciate any help anyone would be willing to offer. Thanks so much, and have a great day! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving worksheets | Excel Discussion (Misc queries) | |||
moving worksheets | Excel Discussion (Misc queries) | |||
Moving Worksheets using VB | Excel Discussion (Misc queries) | |||
Problem saving the file after moving worksheets into another | Excel Discussion (Misc queries) | |||
Moving Between Worksheets | Excel Discussion (Misc queries) |