Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2012, 12:09 PM
Spanec Spanec is offline Chalenge!.. Working with Connected Workbooks Windows XP Chalenge!.. Working with Connected Workbooks Office 2003
Novice
Chalenge!.. Working with Connected Workbooks
 
Join Date: Jan 2012
Posts: 7
Spanec is on a distinguished road
Default Chalenge!.. Working with Connected Workbooks

I have a sheet (FirstTask) that need to be filled more then once per day (same sheet with different entries-COST). Every time when that sheet (is open (reopen to fill another entries-COST) I want to get the final result C10 and put in to a defferent WorkBook (DailyReport) in the end of the day i need TOTAL amount!... Here is the sample attached..

Thanks if somebody can help me with!
Attached Files
File Type: xls DailyReport.xls (14.5 KB, 4 views)
File Type: xls FirstTask.xls (13.5 KB, 2 views)
Reply With Quote
  #2  
Old 01-13-2012, 10:40 AM
Catalin.B Catalin.B is offline Chalenge!.. Working with Connected Workbooks Windows Vista Chalenge!.. Working with Connected Workbooks Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

And a simple link between workbooks is not enough?
=[FirstTask.xls]Sheet1!C10 and so on...
If you don't know to create and change the links in a workbook, try these steps:
with all your workbooks open, in a cell in daily report.xls type the equal sig
n = then activate the workbook first task .xls and click cell C10 in Sheet1, then press enter ; you will have this formula in daily report: =[FirstTask.xls]Sheet1!C10 . Do the same for the other workbooks.
If you change the location of the linked work, you have to change the links to indicate the new location. In daily report, on the menu line, click on Edit-->Links ; a dialog window will show; select the source file needed, then click on change links, and browse to the location of your file, select it click ok. Whenever you open daily report, the links will be updated with the new values from source files if you make the necessary settings:
Don't ask whether to update links when I open any workbook, and update links automatically: This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs.
  1. On the Tools menu, click Options, and then click the Edit tab.
  2. Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed.

Don't ask to update links for this workbook, and let me control whether links are updated
Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.
  1. On Edit menu, click Links.
  2. Click Startup Prompt.
  3. Select the option you want.

Note You will still be notified if there are any broken links.
source: http://office.microsoft.com/en-us/ex...005199380.aspx
http://office.microsoft.com/en-us/ex...005203695.aspx
Hope this answers your problem...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link multiple excel workbooks to publisher bandcsaravia Publisher 0 10-24-2011 09:14 AM
Chalenge!.. Working with Connected Workbooks Combining 2 workbooks into 1 workbook with TWO sheets dguenther Excel 1 10-06-2011 03:25 AM
Chalenge!.. Working with Connected Workbooks Image connected to pagenumber MBos Word 1 03-17-2011 09:23 AM
Excel 2010 Workbooks are opening restored UnMortal Excel 0 02-16-2011 05:25 PM
Excel slow when connected with network and switching off server viswaforu Excel 0 07-06-2010 09:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft