Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2001
    Thanked 0 Times in 0 Posts

    Excel 2013 file prints, but can't find it to edit Windows 8.1

    I make an invoice file each month for my husband to fill in and print. My template has heading and footer info, column information, dates for the current month,formulas, etc. This part works.

    My husband treats the file as he would a piece of paper, filling in the information for the dates. Then he usually remembers to save it, and prints it out. Often something interesting happens. Today he showed me that he can print the file he worked on, which is not quite complete, but the Excel edit page shows only a completely new spreadsheet, A B C columns, 1 2 3 rows, no template I did nor data he entered. Excel reports that there are no previous versions. The header on the edit screen shows the same name as the template I saved.

    Is the file that shows on the printer screen somewhere that can be recovered?

    I do struggle with Excel myself, having used it for years without considering myself competent, much less an expert. I have programmed in Machine Language (for you youngsters, that was before Assembler), worked in a variety of newer languages, used the DOS command line. I can edit photos and videos and put several word processors through hoops, but there is something I do not get about Excel. I am also not up to speed yet on Windows 8.1.

    I would appreciate your assistance.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Newcazzle, UK
    Thanked 466 Times in 444 Posts
    Hi Judy

    ..check the tab sheets.
    It sounds like you are perhaps looking at a 'blank Excel sheet in the invoice file e.g perhaps a sheet named [Sheet2].
    Click on the first tab sheet, that will probably be the one that has the invoice data.


  3. #3
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Austin, TX
    Thanked 36 Times in 34 Posts
    'Place all lines below into the THISWORKBOOK module of your file. Change a1 to the cell with your clients name
    Option Explicit
    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Dim myfile As String
    myfile = Range("a1").Value
    'change range("a1") to the range for YOUR customer name
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs filename:=myfile, _
    FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
    Application.DisplayAlerts = True
    End Sub
    Don Guillett
    Excel Developer

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post
    Hi Judy

    You may want to also check what kind of "Print Area" is assigned. In Excel 2013 look at the Page Layout menu tab and there in the Page Setup Group you will find a Print Area dropdown that will set or clear any print area settings.

    Let us know if any of these solutions resolved the issue.


    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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