+ Reply to Thread
Results 1 to 2 of 2

Cells on one tab of a worksheet repeating on another - error

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    London
    MS-Off Ver
    Excel 2003/07
    Posts
    1

    Cells on one tab of a worksheet repeating on another - error

    I have a strange problem with a spreadsheet I've set up. It has several tabs with multiple information on each. The sums on each individual tab are linked to the front tab (which I've used as a summary page), but I haven't put any other links in.

    For some reason, when I type anything in certain cells on one of the tabs (including the summary but not just that), it appears also on all the others, not necessarily in the same place. If I delete it on the the other tabs where it shouldn't be, it deletes the original on the correct tab, which I want to keep. This has been going on for ages, it annoyed me so much I completely recreated the spreadsheet, from scratch, but it's still happening.

    I'm flummoxed! Please can you explain why this is happening?

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Cells on one tab of a worksheet repeating on another - error

    Cells with no functions in them should not update at all.... The only thing I can think of is that there is an event triggered macro working in the backgound... Open the VBA IDE and have a look through the Worksheet code modules for any macro's.. If you find any, you can temporarily disable them by making line 1 of the code Exit Sub
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1