Excel sheet format change when i open it on another PC

By Justinis
Apr 30, 2010
  1. HI guys
    Do you guys experienced this kind of problem? When i finished my excel sheet at home, the format for cells are right. However, when i got to the office and open it for my boss, the cell format changed by itself.

    For example, cell A is set for number only, but when i open it at my office, the format of the cell change to some letters.

    Oh, my office use Ms office business version and my home use professional version. Could that cause the problem?

    Thank you very much for helping .
  2. Archean

    Archean TechSpot Paladin Posts: 5,682   +86

    That is strange. Even if you are using different versions this should not happen.

    Has this happened only once? or it happens every time you do some work at home and take it back to office?

    Does it happens with only this file, or happens with every worksheet?
  3. Justinis

    Justinis TS Rookie Topic Starter

    Thank you for reply Archean
    It happened b4 with this worksheet, I thought that wasn't a big deal. Until yesterday, it happened again. This worksheet is like a financial report with lots of number and formula.
    Other worksheets are fine I think. Just that one. It's actually very strange, i never see this before.
  4. Archean

    Archean TechSpot Paladin Posts: 5,682   +86

    Weird. Well easy fix can be simply cut and paste all of your data into a new workbook and save it with new name. You may have to adjust / reformat column settings etc. but I guess it shouldn't take that long. Regards
  5. Justinis

    Justinis TS Rookie Topic Starter

    Ta, I will try that, see if that could fix this. Cheers :)
  6. ucould2

    ucould2 TS Guru Posts: 271

    Check "Macros" are set correctly (same) between the two computers
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...