+ Reply to Thread
Results 1 to 3 of 3

Excel - auto replication of data

Hybrid View

  1. #1
    Registered User
    Join Date
    11-03-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    2

    Excel - auto replication of data

    Hi, I've been having a wierd problem on my Excel file (Excel 2003, SP3) that has worked fine until recently. When I input something into any cell in one worksheet, it gets replicated in the exact cell in all the other worksheets, and vice versa.

    There is no noticeable linkages, circular loops, etc. Neither could I find any macro scripts in the background.

    The above problem is not present in ealier backup copies of the same excel file. Any idea what is going on? Could the file be somehow corrupted?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Excel - auto replication of data

    Sounds to me as though your sheets are grouped together... open the file, right click on any given tab and select Ungroup Sheets

  3. #3
    Registered User
    Join Date
    11-03-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel - auto replication of data

    Thanks DonkeyOte, you're a savior!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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