1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2013 cell properties

Discussion in 'Business Applications' started by whschimmel, Oct 28, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    Hello,

    We work with an excel sheet with multiple colleagues, This workbook is protected on some columns/fields and the workbook is shared.

    Now we have several columns that keep changing it's cell properties. For instance:
    Column: License Plate, this should have the property general, but every morning a colleague has to manually change it from date to general again, next morning the same thing.

    This colleague has first removed the protection and share, next changed the column property and next put the protection and share on again. In my opinion the right procedure.

    Does anyone have an idea what could be causing this?

    Thanks in advance,
    Wouter
     
  2. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,253
    every morning? Is anyone else working on this at night?

    Can you upload a sample?
     
  3. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    at this moment nobody is working at night, so in this case that is not the problem.

    the file can be found in the attached ZIP file.

    examples of wrong column/cell properties:
    Cell AA11 in sheet: Start --> Should be general in stead of time
    Cell S11 in sheet: ACC --> Should be currency in stead of time

    These properties are changed daily.
     

    Attached Files:

  4. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,253
    before I open it, this is dummy data, correct?
     
  5. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,253
    take a look here......I fixed it, but no clue if it will hold over night......I also saved it as a different template to see if that helps.
     
  6. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    yes I removed as much data as possible.

    where can I find your file?
     
  7. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,253
    it was too big to upload......
     
  8. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    I had the same issue, therefore I made it into a ZIP file which has a larger data limit
     
  9. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,253
    derp. busy day, my apologies
     

    Attached Files:

  10. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    Can I ask what you have done to resolve this?

    I will monitor the file tomorrow morning to see the cell/column properties
     
  11. whschimmel

    whschimmel Thread Starter

    Joined:
    Jul 7, 2008
    Messages:
    168
    when I open the file I still see cell AA11 on sheet Start as time and cell S11 in sheet ACC is correct and shows as currency
     
  12. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    77,253
    that should do it.......no clue as to why it resets overnight though.
     

    Attached Files:

  13. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1111671

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice