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

Topic

New Reply

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.

Reply | Quote

Replies

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.

zeddy

Reply | Quote

‘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

Reply | Quote

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.

Cordially

Wassim

Reply | Quote