A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Are Excel links necessary?



 
 
Thread Tools Display Modes
  #1  
Old October 29th, 2004, 02:28 AM
external usenet poster
 
Posts: n/a
Default 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  
Old October 31st, 2004, 04:19 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.