Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bob bob is offline
external usenet poster
 
Posts: 2
Default problem with linked workbook

I have created some workbooks that are linked together.
My budget workbook is linked to four workbooks, Quarter 1 thru 4. I have
been playing around with it and I don't know what happened but when the
budget workbook is open it shows numbers in the cells that are linked to the
Quarter workbooks, problem is that there are no totals in those cells. When
I open up the Quarter workbook the numbers go to zero in the Budget Workbook
like they are suppose to. Any ideas?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,510
Default problem with linked workbook

Hi Bob,

There are a number of reasons why this could occur. Enter 'update links' in
help and you will find something like 'Control when external references
(links) are updated'. or 'Control when links are updated' depending on the
version of xl you are using.

Read through it and it is highly likely you will find what you need to change.

--
Regards,

OssieMac


"bob" wrote:

I have created some workbooks that are linked together.
My budget workbook is linked to four workbooks, Quarter 1 thru 4. I have
been playing around with it and I don't know what happened but when the
budget workbook is open it shows numbers in the cells that are linked to the
Quarter workbooks, problem is that there are no totals in those cells. When
I open up the Quarter workbook the numbers go to zero in the Budget Workbook
like they are suppose to. Any ideas?


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linked workbook cell returns 0 is source workbook cell is blank? Syd[_2_] Excel Worksheet Functions 4 April 13th 09 07:49 PM
pulling color from cell of workbook to another linked workbook Sunshine Excel Discussion (Misc queries) 5 September 28th 07 12:42 PM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Linked workbook(s) Tom Excel Discussion (Misc queries) 1 April 3rd 06 09:39 PM
SumIf - Linked Workbook - #VALUE Lynn Excel Worksheet Functions 1 October 5th 05 09:54 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"