+ Reply to Thread
Results 1 to 9 of 9

Excel documents are BLANK

  1. #1
    Registered User
    Join Date
    02-28-2018
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Question Excel documents are BLANK

    -After using two macros on 2 workbooks and saving them to the personal macro workbook; often my documents are blank when opened and I have to go to review and accessibility to view them. It's been about 4 weeks now.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,897

    Re: Excel documents are BLANK

    What are the macros? Please show all of the code.

    Are all documents blank or only the two workbooks that you used the macros on?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-28-2018
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Re: Excel documents are BLANK

    It's any workbook really.
    Please Login or Register  to view this content.
    Also, This one. I cant delete the old one that was similar to the one above.
    Please Login or Register  to view this content.
    Thanks!
    Last edited by 6StringJazzer; 03-29-2018 at 11:27 AM.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,897

    Re: Excel documents are BLANK

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,897

    Re: Excel documents are BLANK

    I do not see anything in your macros that could affect accessibility settings or anything else that could cause a file to open blank. I suspect it is a coincidence that this problem started when you created these macros. (By the way these macros look like they are from the macro recorder and have a huge amount of unnecessary code. I can help with that but first things first.)

    Could you attach a single example of a workbook that is blank when you open it?

    The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

  6. #6
    Registered User
    Join Date
    02-28-2018
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Question Re: Excel documents are BLANK

    Blank copy when opened. There's a macro I use in the advance tab.
    Attached Files Attached Files

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,897

    Re: Excel documents are BLANK

    This file is not blank when I open it so there must be some issue in your local configuration rather than something in the file. Also you referred to a macro, but is not a macro-enabled workbook and so there are no macros in the file.

    I assume you have completely closed out Excel, and rebooted your machine, and still have the same problem.

    One thing I would try is a Microsoft Office Repair. I do not know what your problem is or whether this will fix it, but it can often fix a range of odd problems.

  8. #8
    Registered User
    Join Date
    02-28-2018
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Re: Excel documents are BLANK

    It's reinstalling office. Will that wipe out my macros?

  9. #9
    Registered User
    Join Date
    02-28-2018
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    24

    Re: Excel documents are BLANK

    I guess it didnt. It still didn't solve the problem though. Can someone else look at my macro's maybe?
    Otherwise, 6stringjazzer wrote "This file is not blank when I open it so there must be some issue in your local configuration rather than something in the file". I could mention this to IT maybe.

+ 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. Separating a documents worksheets into individual documents
    By CWinkler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-30-2019, 07:22 PM
  2. Documents and Settings All Users Documents - Access is denied
    By peterrc in forum Microsoft Windows Help
    Replies: 8
    Last Post: 01-26-2014, 06:30 AM
  3. Excel VBA code to read from Word documents in a folder and Print it to Excel
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2013, 11:04 PM
  4. convert all 97-2003 excel documents to macro enabled documents on server
    By viperisback in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 09:06 AM
  5. Problems with blank box when appending text documents
    By Hjahren in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-17-2010, 08:31 AM
  6. ms excel work coming up blank in my documents
    By 1lkywmn in forum Excel General
    Replies: 3
    Last Post: 08-14-2006, 09:35 AM
  7. excel documents won't open from my documents folder
    By Paul1961 in forum Excel General
    Replies: 2
    Last Post: 01-15-2006, 01:35 PM
  8. [SOLVED] Excel Documents Don't Appear in My Recent Documents
    By Addi in forum Excel General
    Replies: 4
    Last Post: 07-24-2005, 05:05 PM

Tags for this Thread

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