Linking between workbooks and getting #REF error

I am trying to link several excel files into a consolidated excel file.  I 
already linked 3 files to the consolidated, but when I attempt to link the 
4th, I am getting a #REF error.

Here is what I am doing:

I am highlighting the array I want to link from the individual file to the 
consolidated file.  I copy that section.  I go to the consolidated file, and 
paste special.  I choose Paste Link: Microsoft Excel 8.0 Format.

The consolidated file shows the #REF after doing so.  I did the same process 
for the previous three files, and everything worked fine.  Can anyone help?

Thanks,
TM
0
11/10/2005 12:34:02 AM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
553 Views

Similar Articles

[PageSpeed] 7

Reply:

Similar Artilces:

Filtering Error: "You Cancelled the Previous Operation"
I have a form that I've developed that shows data from all over my database, grouping it all together and displaying it for the user's ease of use. There are four status indicator columns on this form, each one either equal to "Green", "Yellow", or "Red". At the bottom of each column is a drop-down combo box I have added that allows the user to filter on a certain color, so they can see what records have a certain status. They can search on "Green", "Yellow", "Red", or "All", which removes all filtering. ...

Cannot get web services edition to connect to Exchange 2010
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Email Client: Exchange I recently installed Exchange 2010 for a client, <br> and i have upgraded Entourage on one of the Macs to Web Services Edition, but no matter how many times i try, i cannot get it to connect to the Exchange server. It just stays as &quot;not connected&quot; and doesn't display any error message. I have tried all sorts of troubleshooting, I can access OWA as the user fine, and i get a responce when i goto <a href="https://servername/ews/exchange.asmx">https://se...

Update links prompt not wanted
I am posting a few files sayb File A and File B (Excel 2003) on a network drive. These files are password protected and are linked to each other where File A is the source file for File B. To suppress the prompt to update when I open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update automatic links'. This has stopped prompting me for updating all files including these 2 files but I understand this is good only for my computer.I would also like all users of these files on the network not to be prompted for updating but that they open automatically File B wit...

How do I link columns from one worksheet to another in the workbo.
I am trying to enter data in a column of one worksheet and have the data show up in another worksheet in the same workbook. I have tried to highlite the colum and use "=" : highlite the other colum on the other wroksheet and hit <enter>. This does not work. Any suggestions? Feather AFAIK this cannot be done on entire columns. Enter the = sign in A1 then switch to other sheet and select A1 and ENTER. Now just drag/copy that formula down as far as you wish. Gord Dibben Excel MVP On Tue, 19 Apr 2005 10:53:02 -0700, Featherstony <Featherstony@discussions.microsoft.c...

Purchase Order Error #3
The users are trying to get into the PO search to print off approved PO’s. Every time they get to the area of bringing up the PO thier machines locks up. We have checked and no one is in Dynamic’s entering PO’s at these time. If they try to end the task Dynamics closes. ...

Publisher 97 Startup Error
When I start up Publisher 97 recently, I have been getting a undialog.cpp error. How do I stop this happening? The only reference we can find to this error is in conjunction with ZoomText and how it handles clipart. Undialog.cpp Error Message When inserting clipart into a Microsoft Office application with ZoomText running, the Office app would display an "Undialog.cpp" error. This problem has been fixed in version 7.01. http://www.aisquared.com/Support/Index.htm My recommendation would be to re-install Publisher in safe mode. It is a programming error. Compact your Gallery, righ...

ESM gives error c1030af0
Recently I changed the IP address of my server, and ever since I cannot view the properties of the public folders. When I attempt to I get an error: -------------- The operation failed due to an invalid format in the HTTP request. Verify that the host header is correct for the virtual server. ID no: c1030af0 Exchange System Manager -------------- I have already verified that IIS default web page IP has also been changed to match the NIC's first (of two) IP address. Make sure the web site in IIS that answers requests for Exchange can answer requests via it's own host name. I ha...

embedded object error (pdf file)
I have two new computers. Dell latitude laptop and dimension desktop. I am converting an excel file to pdf format and trying to insert it as an object in an excel file so people can double click on it and view it. I used to do this with my old laptop (purchased new in 2004 Dell Latitude) It worked fine with that laptop. I am taking an excel file and converting it to pdf format using a program I purchased called personal converter. Then opening the other file and clicking insert, object, create from file (and display as icon). I get the following error on the laptop "cannot insert objec...

Error When Merging Two Records
Greetings! When trying to merge the contents of two records, our users get an error: "An error has occured. For more information, contact your system administrator" Which is followed by an IE Script Error: "'crmMergeForm' is undefined" At first I thought it was a permissions issue, however every one of our security roles has full rights on Merge in the Miscellaneous Privileges section. This error even affects those with administrative rights. Any suggestions? Thanks in advance. Herb I am also having this problem! Please help! ...

Get your ClickBank ID on Thousands of Sites all over the World!
Imagine... Your Clickbank� Affiliate ID on Thousands of Pages All Over The World Making You Big Money 24 Hours A Day 7 Days A Week -100% Absolutely FREE! Build A Monster Ad Network of People Ready, Willing and Waiting To Advertise Your ID on Their Websites! This is Not A Wave of Opportunity... This is a Tsunami! A wave merely goes at it's own pace based on the currents of the ocean. A Tsunami is a giant wave up to 150 feet in height which can go up to 600 miles an hour and destroys anything in it's path. CBClicks is a Tsunami and it's merely the start. Ride the CBClicks ...

Outlook Synchronization Error
Hi I have a problem trying to synchronize offline folders with the Exchange Server. I have a Exchange 5.5 - SP 4 (running on window 2000) and having problem with Outlook 2000(SR-1a) and 2002(SP2). When synchronization is completed, a synchronization log is created in the deleted folders as below. 12:12:00 Synchronizing Hierarchy 12:12:00 Synchronizing Favorites 12:12:00 Synchronizing Folder 'Inbox' 12:12:16 5 item(s) added to offline folder 12:12:16 Error synchronizing folder 12:12:16 [80004005-501-50A-550] 12:12:16 The client operation failed. 12:12:16 Microsoft ...

Can't seem to read PDF files, keep getting a 1402 error message
Tried loading Adobe reader and keep getting a Error 1402 could not open key message. Here is what the message looks like. HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/WINDOWS/CURRENT VERSION/RUN/OPTIONAL COMPONENTS/MSFS Help! Have you tried completely Uninstalling it and re installing it? Russ -- Russell Grover - SBITS.Biz [SBS-MVP] Microsoft Gold Certified Partner Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Second Opinion $15 - www.PersonalITConsultant.com Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com &q...

To get the CSliderCtrl to move the just place where user clicked.
I am using CSliderCtrl and there is one thing I want. I want the button to get to the place where the user clicked. In default way, it moves to right or left with page size. So, I tried to calculate the position where the user clicked from the slider's channel rect and mouse position and set the position with SetPos. But there are two problems. (1)The button moves two times when user clicked it every single time. (2)The channel rect is larger than the area where the button is able to move.So I can not calculate the exact position. Any ideas? Thanks!! ...

error 1706 running Office 2000 in Windows XP Home
Program is loaded. No problem starting in administrator log in. On a different user, starting Excel results in error 1706, but after clicking OK, Excel starts. What's the glitch? The information in the following MSKB article may help: OFF2000: Error Message: The Feature You Are Trying to Use Is on a Network Resource That Is Unavailable http://support.microsoft.com/default.aspx?id=224097 david wrote: > Program is loaded. No problem starting in administrator > log in. On a different user, starting Excel results in > error 1706, but after clicking OK, Excel starts. ...

Getting Color Separations Right
Publisher 2002/Win XP Home SP1 I'm sure these basic questions/problems, but I'm stuck with my limited knowledge of color separations. My printer called me yesterday to pick up my 24-page newsletter, because when she prints the color separations (Pantone Blue 2757C) and CMYK black, some things that are supposed to be blue either don't show up or show up black, even though I thought I was careful in defining it all the same. I tried saving my front page logo graphic in various different formats, to no avail. I go through and see no difference in the definitions of the blue things...

Import or link a Label from Word to Access
How do I import or link a Label created in MS Off 2007 Word to a MS Off 2007 Access in order to to link it to a Table. My Label in Word contains more lines to the Label in Access. -- Roger You can't import the Word label. You will need to recreate the label in Access by using the label wizard. You will see it when you press New on the Report tab of the database window. "Roger" <Roger@discussions.microsoft.com> wrote in message news:1DE7F240-F56C-4188-A754-A3C49AC10C5B@microsoft.com... > How do I import or link a Label created in MS Off 2007 Word to a MS Off &...

error code "publisher cannot load files from a different version"
yes a popular error i know. but no i do not have norton basically the computer crashed, i had to reinstall everything, now previously made pub's on office 2k will no longer load on publisher 2k. or on another version of publisher 2k. i looked into the files and they do say publisher 3 embedded in the codes. i am at a loss as to what to do, i have hundreds of files , i havent checked them all of course Do an installer cleanup, Description of the Windows Installer CleanUp Utility http://support.microsoft.com/default.aspx?kbid=290301 -- Mary Sauer MS MVP http://office.microsoft.com/...

msinm.exe application error
I have Outlook Express running under XP Home edition. I keep getting a send receive error and when I close Outlook I get the message msinm.exe application error instruction 1x77f58d2c couldn't reference memory at 0x009a4760. Any thoughts/ cliff <anonymous@discussions.microsoft.com> wrote: > I have Outlook Express running under XP Home edition. I > keep getting a send receive error and when I close > Outlook I get the message msinm.exe application error > instruction 1x77f58d2c couldn't reference memory at > 0x009a4760. > Any thoughts/ Ask in an Outlook Ex...

Data Synchronization Error
When I go online with a few of my CRM For Outlook Clients I get a 'Data Sychronization Error'. I am then provided with three options: 1. Proceed with going online, but save the data changes offline for the next time you synchronize. 2. Stay offline and try to fix the errors so all the data will synchronize 3. Finish going online and do not save the data changes made offline Here are some error examples which appear next to each piece of offline data: 1. Invalid activity regarding object. It probably does not exist 2. the record you are requesting is currently unavailable Any help ...

Authentication Error 11-12-07
Good Day Board, After getting PROBLEM 2 listed in this document (http://support.microsoft.com/kb/916568) I decided that I would try the CRM nonetheless, so I fire up my browser and type in http://servername:5555/ after awhile I get an authentication error with the following text "Microsoft CRM could not log you on to the system. Make sure your user record is enabled and that you have been assigned at least one security role." Any help here would be greatly appreciated. Thanks. Please try to re-start your CRM server . /Aamir Restarted the server, got the same authenticati...

Free Class to get and set Font Smoothing
#define FE_FONTSMOOTHINGSTANDARD 1 #define FE_FONTSMOOTHINGCLEARTYPE 2 #define SPI_GETFONTSMOOTHINGTYPE 0x200A #define SPI_SETFONTSMOOTHINGTYPE 0X200B #define SPI_GETFONTSMOOTHINGCONTRAST 0X200C #define SPI_SETFONTSMOOTHINGCONTRAST 0X200D class FontSmoothingType { private: BOOL FontSmoothingEnabled; UINT TypeOfFontSmoothing; void GetFontSmoothing(); void ResetFontSmoothing(); public: FontSmoothingType(){ GetFontSmoothing(); }; ~FontSmoothingType(){ ResetFontSmoothing(); }; void SetClearType(); void SetNoSmoothing(); }; void FontSmooth...

How do I get my website created with publisher to show properly
Can you help, please I'm desperate: i created my website in publisher 2003, it seems to work great in IE, i'v gotten it to work in Opera, Mozilla etc., but I'm having problems with the bottom nav buttons, they won't work, the nav on the left side does. Is there a way of me importing my website into another program so I can make changes and update in an easy manner? Thanks any help would be much appreciated. I presume that the bottom navbar works when viewed with IE, but doesn't when you use another browser. One workaround I know about is to replace the bottom navb...

SDK error -> HTTP status 401: unauthorized.source:System.web services
Hi all, I am using the SDK to build a custom aspx page that simply extracts the 'fullname' of every user in the 'systemuser' entity and assign it to a particular field in the Opportunity form. This is because the client needs a user to be assigned to an opportunity as the owner of the opportunity will not necessarily be working on it. I have Visual Studio and therefore development performed on my local machine and MSCRM is installed on a virtual server. I have managed to bring the custom aspx page up from the MSCRM server without any issues but have not been able to make a co...

linking drop down lists
hi, im trying to create a user friendly spreadsheet. i have 2 columns need help with. in the first column i have created a drop down list containing continents of the world. in the second column i want another drop dow list to display only the countries from the continent selected. fo instance. in the first column i have selected africa. how can i make i so that when i have selected africa from the continents drop down list to make the cell next to it (the countries drop down list)( only giv the option of selecting a country from africa instead of all th countries of the world -- reading2...

New error on opening outlook 2002
I had accidently installed Plaxo, the address book update program. I uninstalled it and immediately after, started getting an error when I open Outlook: "Microsoft Visual C++ Runtime Library" is the window heading. The message is: "Runtime error! Program C:\Program Files\Microsoft Office\Office 10 \outlook.exe The application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information" After shutting down Outlook and opening again, it takes about four times as long to open, but opens succ...