If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Are Excel links necessary?
We are a group trying to work inserting different areas of information into a
20 sheet workbook with macros. In an effort to allow all to work at once, we made four working copies of the master workbook for each to work on. The idea was, each would work on a different page, when finished copy the page into the master, save the master as itself and a new working copy and continue with another page not being worked on. Come to find out, each time a page was copied and pasted into the master, a link was made back to the working copy. Is there some way to copy pages of like formatted workbooks without creating links, while keeping the macros and formulas of the destination file intact? Thanks. ps. Does anyone know a way of getting e-mail tech assistance from Microsoft once a claim has been started by phone (I had to hang up before someone could help…1/2 hour at $1.80/min cell from Caymans….TOO MUCH!!) |
#2
|
|||
|
|||
Bill Manville answered your question in one of your other postings
in this group. Please post a question only once and most of us are into several newsgroups so posting to multiple groups wouldn't do you any good either. In response to your other question, don't you find the help in the newsgroups better than calling Microsoft, after all they have to field any question they get; whereas, in a newsgroup we get to pick and choose what questions we think we can answer. On the other hand if you have a question that you really need Microsoft to help you with you could be on the phone for hours. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm " m wrote in message ... We are a group trying to work inserting different areas of information into a 20 sheet workbook with macros. In an effort to allow all to work at once, we made four working copies of the master workbook for each to work on. The idea was, each would work on a different page, when finished copy the page into the master, save the master as itself and a new working copy and continue with another page not being worked on. Come to find out, each time a page was copied and pasted into the master, a link was made back to the working copy. Is there some way to copy pages of like formatted workbooks without creating links, while keeping the macros and formulas of the destination file intact? Thanks. ps. Does anyone know a way of getting e-mail tech assistance from Microsoft once a claim has been started by phone (I had to hang up before someone could help.1/2 hour at $1.80/min cell from Caymans..TOO MUCH!!) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Links | Ryan | General Discussion | 2 | July 16th, 2004 03:46 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Random links occuring in linked object from Excel | Kelly | Tables | 1 | June 15th, 2004 03:37 PM |
Excel Links to files on network not updating | Bobbie Jo | Worksheet Functions | 0 | January 13th, 2004 09:02 PM |