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
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Links and Linking Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How to change a file name in formula =[Data1.xls]Sheet1!$A$1 by Viks E.
I have a file Summary.xls. There 100 files Data1.xls, Data2.xls, ... , Data100.xls Data files are identical. All files contains a value in cell A1. I have...
May 26th, 2007 11:17 AM
by Gary''s Student Go to last post
3 266
Application that separates Excel rows in new worksheets by Shinra14
Hello, I was wondering if I can do the below with links in excel: I want to create an application that will read an excel file that contains the names of...
May 25th, 2007 11:30 PM
by Gary''s Student Go to last post
1 258
display links by Linda@LLBean
I would like to know if it's possible to "show links" that are in an existing document. I want to show the user what links are embedded in the document. ...
May 24th, 2007 02:52 PM
by Linda@LLBean Go to last post
5 491
Locating Links and Removing by rmcompute
Every time I load this worksheet it prompts me to update the links. The worksheet it's looking for does not exist. How can I determine where on the...
May 21st, 2007 02:12 PM
by Linda@LLBean Go to last post
1 217
Error when updating links by RWilliams
I have a number of workbooks that manage resources for projects - There is a 'Master' workbook, that provides information about the status of the projects,...
May 15th, 2007 06:19 PM
by Bob Flanagan Go to last post
4 421
formatting in links by chumley
I am using a named range as a link in an Excel chart title. Is there any way to maintain the formatting used in the original cells in the range?
May 15th, 2007 05:54 PM
by chumley Go to last post
0 151
link trouble by brownti via OfficeKB.com
I have a worksheet that has about 1700 links to another worksheet on it. When the file is in use the values that are linked will not change, however they could...
May 14th, 2007 02:53 PM
by brownti via OfficeKB.com Go to last post
0 160
Importing Access Queries by Bill
Hi All, I'm trying to import a data from a query in an access mdb file but can only see a few of the queries. There is no reason that I can spot why some are...
May 12th, 2007 07:58 PM
by Nick Hodge Go to last post
1 173
Trap show toolbar event by [email protected]
Issue: I have a Custom toolbar that I want displayed only on certain conditions. Questions: 1. How can I trap the event generated by making this excel...
April 27th, 2007 04:16 PM
by [email protected] Go to last post
0 190
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. by tln[_2_]
I'm trying to either copy images (cut and paste) or insert pictures (Insert Object) into my Excel worksheet and then link them to a Word document. I cannot...
April 22nd, 2007 04:28 PM
by tln[_2_] Go to last post
0 194
p value by Ali
I would appreciate it if some one tells me what functions or add-ins to use to calculate P-value. Regards
April 22nd, 2007 01:05 PM
by Jan Kowalski Go to last post
3 194
How to get sum of data in series from 2 Workbooks to another Workbook by adeel via OfficeKB.com
I have 2 workbooks with series of numeric data (i.e A1 to A100 in both workbooks), I want to generate automatic Sum of these data in another workbook (Cell by...
April 22nd, 2007 11:54 AM
by FloMM2 Go to last post
1 434
How can I count the number of links? by Mr Clone enolC
My spread sheet has a column of hyperlinks. About 100 of them. They are jobs I've applied for from the job sites. Is there a way I can search through the...
April 21st, 2007 08:55 PM
by Dave Peterson Go to last post
1 169
Long delay opening a workbook through our Intranet for some users by Jacques Trépanier
Hi, We have 5 sites and in one of them about half the users have a very slow response time when opening a small (386kb) excel file through our Intranet that...
April 20th, 2007 08:58 PM
by Jacques Trépanier Go to last post
0 152
Enable Command Button base on UserName by Doctorjones_md
I have a Command Button on a worksheet that I only want to display if a specified User Opens the workbook. I have the following code: (in a UserName...
April 20th, 2007 07:16 PM
by doctorjones_md[_2_] Go to last post
6 270
Links sent via Email not working by Richard
I have just set up a source and destination workbook on my pc. The results were excellant. I then emailed both to a colleague with who their is no common...
April 18th, 2007 12:48 PM
by Richard Go to last post
0 139
Excel 2007 Destroys Links In Excel 2003 Files? by Gus
Hello- I am a network tech upgrading folks to Office 2007 from Office 2003. We have found that when opening Excel 2003 in Excel 2007, links are broken that...
April 16th, 2007 09:52 PM
by Nick Hodge Go to last post
2 189
Help How to update linked .xls offline with MS-ACCESS (VB)? by Yaff
Hi guys, How can get an excel file to update itself offline? The context: TEST1.XLS TEST2.XLS is linked to test1.xls (ie a cell in test2...
April 14th, 2007 02:40 PM
by Yaff Go to last post
0 147
Counting Specific Number of Days across Multiple Months by [email protected]
I have a task which seems relatively easy at first. I have two dates as inputs: a start date and a stop date that can vary between dates and lenght of time. I...
April 14th, 2007 12:29 PM
by Max Go to last post
1 168
Red face
Automatically update data across worksheets by Lancashire Lass
I have an Excel worksheet containing 4 worksheets. The main data is in Sheet 1. I need to update certain cells in Sheet 1 regularly and those cells are...
April 6th, 2007 12:53 PM
by JE McGimpsey Go to last post
1 220
Post New Thread


Display Options
Showing threads 361 to 380 of 1285
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
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


All times are GMT +1. The time now is 03:09 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.