Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 04, 10:13 AM
DavidA
 
Posts: n/a
Default Incorrect Links between cells

Excel 2000 SP2
We have a budget spreadsheet that links various worksheets within the same
workbook. Occasionally when a new budget is entered the links carry data into
the wrong summary worksheet cells and corrupt the total data. We have run
formula editing and can find no errors.
The only temporary fix is to run detect and repair. This is very frustrating
as this spreadsheet is used on a daily basis for new budget spreadsheets.
TIA
David

  #2   Report Post  
Old December 15th 04, 07:50 AM
Bill Manville
 
Posts: n/a
Default

DavidA wrote:
Occasionally when a new budget is entered the links carry data into
the wrong summary worksheet cells and corrupt the total data

To enable us to help you I think we will need more information.
What is the formula in the cell that gets the "wrong" data.
What is the data in the cells that are referenced by that formula.
Why are you expecting something different?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
Old December 15th 04, 09:07 AM
DavidA
 
Posts: n/a
Default

The data appears in the wrong cell in the wrong worksheet but upon close
investigation can be traced to another cell on another worksheet within the
same workbook. There is no formula in the offending cell.
The cell then corrupts the total of the column it is falsely appearing in.

The originating cell for the erroneous data is usually an =sum() formula.
Hope this helps. It is difficult to describe!

"Bill Manville" wrote:

DavidA wrote:
Occasionally when a new budget is entered the links carry data into
the wrong summary worksheet cells and corrupt the total data

To enable us to help you I think we will need more information.
What is the formula in the cell that gets the "wrong" data.
What is the data in the cells that are referenced by that formula.
Why are you expecting something different?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


  #4   Report Post  
Old December 15th 04, 02:07 PM
Bill Manville
 
Posts: n/a
Default

DavidA wrote:
It is difficult to describe!


...and difficult to understand exactly what you mean.
Please could you give the detail.

What cell contains the incorrect data?
What appears in the formula bar when you select that cell?
What are the contents of the cells to which that formula refers?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



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
Skip blank cells in diagrams hlp Charts and Charting in Excel 9 February 24th 06 02:32 PM
Trendlines to ignore empty cells Hoochi Coochi Man Charts and Charting in Excel 7 January 14th 05 01:31 PM
Strange Problem with Chart and Plot Visible Cells Option Marcus Leon Charts and Charting in Excel 1 January 7th 05 03:52 AM
To get a lot of charts that refer to different cells Anderson Lee Charts and Charting in Excel 1 December 28th 04 02:35 PM
Excel Charts and cells sacha Charts and Charting in Excel 1 November 30th 04 02:30 PM


All times are GMT +1. The time now is 06:42 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017