Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel

  • 20-09-2006 11:08am
    #1
    theshadow
    Registered Users, Registered Users 2 Posts: 119 ✭✭


    Hi there, have an Excel worksheet used to keep customers details. Anyway, recent upgrade from office 97 to 2003, also sharing workshare with others in the office. Recently when someone changes a cell, say date of birth, the contents of the next three cells in the column are changed next I open the document. Anyone see this before? Is it to do with sharing?
    Thanks in advance.


Comments

  • #2
    subway
    Closed Accounts Posts: 6,131 ✭✭✭subway


    what do you mean exaclty?
    what are the contents of the next 2 cells?

    if you change a customers date of birht your saying it changes his names and address too?


  • #3
    theshadow
    Registered Users, Registered Users 2 Posts: 119 ✭✭theshadow


    If you change say the the DOB of one customer then the DOB of the customer two rows down will change and again the customer four rows down will also change to the same. The rest of the fields in the row remain the same.

    xx/xx/xx
    19/09/06
    xx/xx/xx
    19/09/06
    xx/xx/xx
    19/09/06
    xx/xx/xx/
    xx/xx/xx/
    xx/xx/xx/


  • #4
    subway
    Closed Accounts Posts: 6,131 ✭✭✭subway


    the obvious thing is that it sounds like theres a formula in place.
    without seeing the spreadsheet i couldnt say for certain.

    you could try pasting all the dat to a new sheet
    right click "paste special" then select values to see if that fixes the issue [any forumals will be removed]


  • #5
    jubi lee
    Registered Users, Registered Users 2 Posts: 292 ✭✭jubi lee


    press F2 in one of the cells and read off the formula. it should tell you what is happening. post formula on here if you wish


  • #6
    theshadow
    Registered Users, Registered Users 2 Posts: 119 ✭✭theshadow


    subway wrote:
    the obvious thing is that it sounds like theres a formula in place.
    without seeing the spreadsheet i couldnt say for certain.

    you could try pasting all the dat to a new sheet
    right click "paste special" then select values to see if that fixes the issue [any forumals will be removed]

    Sorry for the delay in replying, away for a few weeks. Must have had a few formulas scattered around the spreadsheet. Anyway creating new spreadsheet and using paste special seems to have done the trick. Thanks again.


  • Advertisement
Advertisement