+ Reply to Thread
Results 1 to 6 of 6

.xlsm file not displaying cells at correct size

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    .xlsm file not displaying cells at correct size

    Hello all. I have received a .xlsm file from a colleague and it is not displaying cells at the correct size (everything is squished as though the column width for everything is the default size). I am using Excel 2007. The file was sent to several people and it is displaying correctly for all but 2 of us. We are all running the exact same version of Excel. Both myself and the other person experiencing the problem have never had an issue like this before. I did notice that upon opening the file it was flagged as being from an untrusted source and thereby macros were disabled but even after dealing with that it still doesn't display correctly. Another thing I noticed in the file was the lack of values on the top and sides of the grid for column and row positions. I'm hoping somebody can tell me why the file is not displaying as it should for myself when it is for others. Thank you.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: .xlsm file not displaying cells at correct size

    Just confirm have you enabled the Macro which you will see at the time of opening the file?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    06-05-2013
    Location
    Oklahoma
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: .xlsm file not displaying cells at correct size

    Try checking your zoom. With certain fonts in Excel, zoom can do some pretty funky stuff.

  4. #4
    Registered User
    Join Date
    10-15-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: .xlsm file not displaying cells at correct size

    Yes I have enabled macros for the file.

  5. #5
    Registered User
    Join Date
    10-15-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: .xlsm file not displaying cells at correct size

    Zoom doesn't seem to affect it in any meaningful way. The cells are all still squashed up.

  6. #6
    Forum Contributor SCLai's Avatar
    Join Date
    08-18-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: .xlsm file not displaying cells at correct size

    Perhaps you can post a screen shot of what you are seeing, as well as the file in question so that we can try to figure out what may the problem be?
    Do give a * (bottom left) if the post helped!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  2. File size reduction _ Macro-Enabled Worksheet (.xlsm)
    By berger01 in forum Excel General
    Replies: 3
    Last Post: 02-21-2013, 10:49 PM
  3. Replies: 6
    Last Post: 01-20-2013, 09:52 AM
  4. Save file xls file as xlsm - macro won't run in xlsm workbook
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2012, 11:39 AM
  5. File Size Difference with xlsm and xlsb
    By aftabn10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2011, 01:05 PM

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