Consulting

Results 1 to 14 of 14

Thread: Opening XLSM file with Excel 2007 does not display content

  1. #1

    Opening XLSM file with Excel 2007 does not display content

    Hi everyone
    - I opened xlsm file with office 2007 but it didn't display the content. I have enabled all macro, VBA
    - My computer is using Windows 10
    - Please help me
    file1.jpg

  2. #2
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    It cannot be excluded that the file window is hidden. Go to View tab and find Unhide button. Press it.

    Artik

  3. #3
    Quote Originally Posted by Artik View Post
    It cannot be excluded that the file window is hidden. Go to View tab and find Unhide button. Press it.

    Artik
    Unhide button is locked, I don't know why I can't open xlsm file, while I enabale all the macro, vba tool
    Thanks you for the reply
    aaa.jpg

  4. #4
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    After "opening" the file, go to the VBA editor (LeftAlt+F11) and see if it appears in the list of open projects. If it is not there, it is likely that the file has not been opened. In this case, it could be blocked by Excel.
    Unfortunately, I don't remember now where, but somewhere in Excel is a place where you can see a list of blocked files.

    Also read this article: https://support.office.com/en-us/art...d-1e6563e7686d

    Artik

  5. #5
    I tried to do as you said, VBA Editor is notthing, and list of blocked files - File block setting - trust center is only available in higher excel version, Where can I find it in office 2007?
    bbbb.jpg

  6. #6
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    Unfortunately, MSO 2007 was a very short episode in my life. I no longer have access to it.


    But another thought occurred to me. Maybe the macro is written so that if a condition is not met, the file is not opened. Admittedly, it seems to me that you should see for a moment that the file has been opened. If you want to go this way, change the settings in Excel so that files are opened without running macros (or at least you must agree to run them; in this case, do not agree to run macros). Try to open the file again without running macros. If the workbook shows up, it may mean that you need to look for the solution in the code. If the workbook is still not visible, it will indicate that Excel has blocked it.


    I probably don't have more ideas.

    Artik

  7. #7
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    @Artik

    In that case the file can be opened with macros disabled (shift-Open).

  8. #8
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    Yes, but remember that it works only from the Excel interface. It will not work if you double-click to open a file from the file manager.

    Artik

  9. #9
    - I still cannot open it, today I checked all computers in my office (15 computer) and i found only one computer that can open xlsm files, I checked excel option like that computer but still cannot open files.
    - All computer use window 10 and office 2007
    - What should I check more??, File blocking setting excel 2007 (i did not find it), regedit, defaut program, macros' code, or.....
    Haizz, I am feeling confusing for this case
    Thanks you for reply

  10. #10
    someone help me, please !!!!

  11. #11
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    How did you open the workbook? From within Excel, or from elsewhere by double-clicking?
    Be as you wish to seem

  12. #12
    - Yes, I have tried everything but it still didn't work, my office has 15 computers and the files I need to open are located in the common server of the office.
    - The problem is: only one computer can open it normally (computer name: tbc-13), the other 14 computers cannot open files like the image I posted above.
    - All computers are using Windows 10, Office 2007, I am looking for the difference between the computer name: tbc-13 and the other 14 computers and I still haven't found it.
    - Do you have any suggestions for me about finding the difference between computer name: tbc-13 and the other 14 computers?
    Thanks you for reply

  13. #13
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    You didn't answer the question and only provided 'information' you provided earlier.

  14. #14
    Quote Originally Posted by fukagawa View Post
    - Yes, I have tried everything but it still didn't work, my office has 15 computers and the files I need to open are located in the common server of the office.
    - The problem is: only one computer can open it normally (computer name: tbc-13), the other 14 computers cannot open files like the image I posted above.
    - All computers are using Windows 10, Office 2007, I am looking for the difference between the computer name: tbc-13 and the other 14 computers and I still haven't found it.
    - Do you have any suggestions for me about finding the difference between computer name: tbc-13 and the other 14 computers?
    Thanks you for reply
    I answered and added information about the location of the files,
    I mean, I installed everything about office 2017 on my computer like computer name: tbc-13, but still can't open the files, I'm looking for a reason.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •