Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

I had a workbook open (not saved) and Windows Update Restarted!!!

I had an Excel Workbook open and Windows Update Automatically Restarted my
computer. All of my changes were lost!!!! This is a major bug. WIndows
should not be allowed to restart if you have unsaved documents open. At
least this option should be customizable.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


Post your answer or comment

comments powered by Disqus
I had an Excel Workbook open and Windows Update Automatically Restarted my
computer. All of my changes were lost!!!! This is a major bug. WIndows
should not be allowed to restart if you have unsaved documents open. At
least this option should be customizable.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I have a workbook with 5 sheets and macros with forms. When I select any one
of the worksheets by the tab with the mouse, the cursor goes to a page and
the only way I can get Excel to stop is to cancel the task.

How do I either fix this workbook or copy all the sheets to another
workbook? TIA
--
Bill

I can't tell if I have a template opened or a standard workbook because the
extension of the filename I open does not show as it did in excel 2002. How
do I enable it so that it shows the extension automatically and by default
(forever)

I had a file named budget. My wife set up another excel 2007 with the name
budget so that when I wanted to go back into "my" budget, I received the
message that since there were two files named budget, I could not open "my"
budget. I renamed the files so each is now different. However, now I can
not open "my" budget. My wife's file budget opens and works normally and I
can open other excel 2007 files with no problem. I have a problem only with
the original "my" budget.

Any help on this would be appreciated!

I have stumped myself again and thought maybe someone would have an "Ohhh yeah, duhh!!!" idea to help me out ...

Basically, I want the excel spreadsheet to "BE Protected" in standard form, and only be "Unprotected" when macros are enabled -- BUT DONT JUMP TO CONCLUSIONS, hear me out, it gets deeper than that ....

If the user does not enable macros, I want the book to be protected. If they do enable macros, it becomes unprotected.... (On load is good enough, no need to be real-time)..... But, they can save the book, so it would no longer be protected , which is where my question comes in ...

I could use the -unprotect "password"- on load when macros are enabled but this will only work if the spreadsheet was originally protected and is never saved again. This is a problem because this workbook will be given to others and will be saved time and time again.

So, I had a vision :-) .... function 'before save' , protect the sheet using -protect "password"- , allow the sheet to save, and then unprotect back using 'unprotect "password"' so you can continue using - BUT, the problem with this is now I have created an endless loop in theory, because after it unprotects it would want to re-save again because it changed ....

So, is there anything else I could do to accomplish this ?
(Protect workbook in excel only, unprotect workbook when macros are enable, and allow changes to be saved..)

Thanks !

Hi there,

I hope someone may be able to help me please?

I have a workbook (workbook A) with lots of data in.
A second workbook (workbook B) is to be found in a location which doesn't change, opened, some sheets copied over and for it to be saved as a copy in the same location as workbook A. I have a code to do this and it seemed to work perfectly.

However I have added a third workbook, workbook C which I want exactly the same thing to happen as with workbook B. The data copied will be slightly different but the process is the same.

When I use the same code for workbook C I don't get a VBA error but it says the excel needs to close and about an error report - could anyone help me with the reason why please and how I can fix it?

My current code is below. Many thanks.

Sub Proceed()

Dim newpathway As String

Application.ScreenUpdating = False

With Sheets("Sheet3")
    .Cells.Copy
    .Cells.PasteSpecial Paste:=xlValues
End With

On Error Resume Next
ActiveWorkbook.Names("Name1").Delete
ActiveWorkbook.Names("Name2").Delete
ActiveWorkbook.Names("Name3").Delete
On Error GoTo 0

newpathway = ThisWorkbook.Path

WorkbookB

Workbooks("WorkbookA.xlsm").Activate
newpathway = ThisWorkbook.Path

WorkbookC
Workbooks("WorkbookA.xlsm").Activate

On Error Resume Next
Application.DisplayAlerts = False
Sheets("Sheet5").Delete
On Error GoTo 0
Application.DisplayAlerts = True

MsgBox ("Please continue in the new workbooks")
Exit Sub

Application.ScreenUpdating = True

End Sub

Sub WorkbookB()

Dim excelfile As String
Dim newpathway As String

excelfile = "WorkbookB.xlsm"
Workbooks.Open "C:My Documents" & excelfile

Workbooks("WorkbookA.xlsm").Activate
Sheets(Array("Sheet1", "Sheet3")).Copy After:=Workbooks("WorkbookB.xlsm").Sheets("Front
Page")

Workbooks("WorkbookB.xlsm").Activate

Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs Filename:=newpathway & ActiveWorkbook.Name
ActiveWorkbook.Close
Application.DisplayAlerts = True

End Sub

Sub WorkbookC()

Dim excelfile As String
Dim newpathway As String

excelfile = "WorkbookC.xlsm"
Workbooks.Open "C:My Documents" & excelfile

Workbooks("WorkbookA.xlsm").Activate
Sheets(Array("Sheet2", "Sheets3", "Sheet4", "Information")).Copy
After:=Workbooks("WorkbookC.xlsm").Sheets("Front Page")

Workbooks("WorkbookC.xlsm").Activate

Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs Filename:=newpathway & ActiveWorkbook.Name
ActiveWorkbook.Close
Application.DisplayAlerts = True

End Sub


I have searched the forum and my book and I can't seem to find the answer to this. I am sure it is simple for the experts here.

I have a Workbook open that imports a user-inputted CSV file. The user makes some changes in the workbook that is then pasted into the CSV file.

I can't figure out how to save the changes to the CSV file and then close it without the user seeing the file being saved and closed.

Here's my code ... please don't laugh ...


	VB:
	
 
Route = Range("j1") 'CSV filename input by user
 
Windows(Route).Activate 
 
Range("A1").Select 
 
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False 'pastes changes
 
Windows(Route).Activate 
 
Application.CutCopyMode = False 
 
Windows("CHERYLTEST").Activate 'main workbook
 
Application.DisplayAlerts = False 'so the user doesn't see what is happening to the CSV file
 
Windows(Route).Close 'closing the CSV file but not saving it.

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Once again thank you in advance for any help.

I'm attempting to write a macro that will copy a range of data and paste it into a new workbook. I think I've figured out the copy/paste part, but workbooks.add does not help me with the new destination. How can I open the 'save as' window, which will cause users to select a path and file name?

thanks in advance

jim

I need a macro that would:
Save the current (original) workbook replacing it if it was already saved

Make changes to it (have code already)
Save it in a different name (have code already)

Close it
Restore the original workbook and make it active

Any thoughts?

I have a workbook names "Space.xls" and when a certain macro is run it goes
and pulls date from a workbook named "Moon.txt". This all works fine.

However, I need a code that will look to see if "Moon.txt" is open and if it
is not to skip that part of the code.

--
Thanks
Shawn

Hello everyone

I am self-taught at Excel and my learning tools have been trial and error along with internet searches on how to do something in particular. This is the first time I cannot find an answer that helps me so joined this community to see if someone knows a better way or how to get this file to open in a reasonable time frame.

I am using Excel 2010, all updated. I am trying to make a training matrix. I have several tabs and at the top running from left to right is a document number and doc title. On the left, running down are names of people. Each tab is a department so everyone in the department is listed. Let's say Employee X was trained on document 1, I would find the cell that matches and put in the date they were trained. That is all simple and straight forward. What I need the file to do is when it is within 30 days of one year of that date, turn the cell yellow. One year and one days past the year, turn the cell red. I got that figured out using conditional formatting.

The problem is, each cell has to have that CF in it. I did a count of cells, total for all tabs and have 11,125 cells with 2 conditional formats in them. Once I started to get a lot of these cells done, the workbook started taking longer and longer to open. The file is just under 5 MB, so still small. It take up to 3 minutes to open now. I had someone else open the file and it took as long. I sent it home and tried on my PC, which just upgraded to an 8 core processor, SSD HD, and all of that and still took a while. I believe it is because it is recalculating each cell when opening.

I disabled auto-recalculations but made no difference. I believe I read that it doesn't shut off CF anyway. I have spent some time making this file but if opening it takes this long, then others probably won't use it and they will need to. I don't know if there is another way to have the cells highlight based on dates past other than maybe a macro, which I don't know macros. Is there an easier way to have them highlight than setting up CF in each and every cell? I tried to do a grouping of cells but the highlighting only works based off of the first cell so that doesn't work.

I need either a different way so it speeds up the opening issue. It will have to auto calculate so when another manager opens the file, he/she can just look for the yellow and red cells so they know who need the yearly training for that month, plus which document/s to train.

Any and all help will be appreciated, especially after spending a week on this thing. Thank you very much!!!

Oh, forgot to mention that when I copy a cluster of cells and paste, it will sometimes lock up the workbook. Even happens if I copy one cell, then paste it 5, 6 or 7 times. This work computer is new and judging by the specs, it should open just fine.

Thank you again!!!

I have a workbook that presents a UserForm to fill in customer date (name, address, etc.) and other various information in Text Boxes. A button on the form then populates a sheet with the customer data (as well as the other various information) that was entered on the form. I need to save a copy of this workbook because I may need to come back and make some changes (other than customer data) to some of the other various entries on the UserForm. My problem is that when I save and reopen the workbook, and press the button to present the form, the customer data is gone and I have to retype this everytime. This data is contant through the live of this copy of the workbook. I there a way that if I reopen the workbook, hit the button to present the UserForm again, that the customer info will still be there (in other words save the customer data from the initial entry)?

At a certain point in my macro, the User can make a decision to create a new
workbook (called "Investment Quotation" as shown below). A small portion of
the macro is shown, below. At that point, the macro performs a
copy-and-paste from the current workbook to a new workbook. When that
happens, I need to prevent the original (first) workbook from being saved. (I
won't know the name of the first workbook.)

The problem is that I want the User to have the right to save/change the
original workbook. It's just that I'm trying to prevent them from saving the
original workbook ONLY if they decide to create a new workbook.

So, I guess my question is: how do I tell Excel to "don't allow a save" to
the first workbook? (Again, the User is allowed to save the file BEFORE
this part of the macro is executed.)

Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "Investment Quotation"

I have a workbook that used to fill the screen when opened. Now when I open
it, it appears in a small window and I cant resize or maximise it as all the
standard buttons on this small window have disappeared!!! Please help!

Here is the scenario:

Macro written/recorded in a blank workbook.
Macro is written to open two other files - an excel file and a .txt file
All files are on a shared drive (here at work)

When I go to save the blank workbook (the one in which the macro "lives"), I get a message - "document not saved".

I write/record macros all the time and I've never gotten this message before. I tried saving all files involved to my hard drive...still got the error message. Can anyone come up with a reason/solution? I've been searching the net all morning...none of the scenarios that I've come across match mine exactly. Thanks.

I had a workbook with the following code to e-mail the workbook to another employee.


	VB:
	
Workbooks("NewphoneLog").SendMail Recipients:="Associate Name", Subject:="Phone Log - " & Format(Now(), "mm/dd/yy") 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This code used to work fine. I have not needed to use the code in a long time. Now I have need to use it for another workbook. When I attempt to use it, I now get a "Run-Time error9" "Subscrip out of range" error.

I looked at the referances and made sure the Microsoft Outlook 9 library was checked but still no luck.

I did find the following her on ozgrid:


	VB:
	
ActiveWorkbook.SendMail Recipients:="Associate Name", Subject:="Test Mail" 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This works just fine.

Any Idea why one works and not the other?

When I try and save a workbook, I get a message that says save a copy or
overwrite changes. Why am I getting this message?

Can anyone shed light why one of event procedures is not running.

I have a couple of workbooks whose formulae can link in either direction
depending on a control value held in a third "control" file. In order that
the status of that third file is always recognised I created a Workbook.Open
Event Procedure that Opens the control file if it is not already open. That
runs fine.(The procedure is held in Thisworkbook)

Recently I was fed up with getting too many divide by zero errors so I
included a small user-defined function in a code module to handle this. Now
my Workbook.Open Event procedure won't fire. If I remove the user-defined
function it fires. Confused? I was!

Anyone any ideas as to what is happening?

I read two pages on "Workbook_BeforeClose" trying to find a relative answer, no luck.

I want to able to close a workbook with out saving and not rely on the user pressing the correct button, can this be done?
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'================================
    Sheets("Part Number").Activate
    ActiveSheet.Protect ("xxxx")
    '================================
    Sheets("FAIR Required").Activate
    ActiveSheet.Protect ("xxxx")
    '================================
    Sheets("Part Number").Activate
    Range("A3").Select
    If bLogin = True Then
    ActiveWorkbook.Save
    Else
    'close with out saving

    End If
End Sub
Thank you

I have a workbook with financial information listed. There are several
columns that I do not want people to see, so I've hidden them and protected
the worksheet. This works fine.
But now I need another group of people to view the hidden columns on another
sheet. I need this other sheet to update automatically when changes are made
to the first.

Please help

Sam.

I have a workbook with numerous sheets and lengthy procedures and functions.
The size of the workbook has reached 3mb at a bare minimum which obviously
increases as more data is entered. I have over 200 clients with repeating
projects annually. The workbook is used for each client and saved as a
separate file with that client's name and the year. So for a given client,
I could have many years' files - as many as 15 years so far. Obviously,
over time, this can take up a lot of hard drive space - which is not the
primary problem given the prices of hard drives.

The main problem is that processing (recalculating) takes a long time even
though I have 2.4 GHz P4 with 512MB RAM.

Two questions:
1. How to reduce the workbook's size (of course without deleting
sheets/modules or splitting the workbook) - is there a utility in Excel
similar to the compacting database in Access.

2. How to speed up recalculation.

Thanks.

Basharat.

This is a repost from a few days ago that wasn't solved. I'm hoping some new expert eyes will be able to help. Thanks...

I have a workbook open that contains 12 worksheets. I would like to rename, save and email someone one of the worksheets as a PDF file. Any suggestions?

Thanks again !!

How do I create a graph from an equation and not a set of data?

Hi everyone,

If I have a workbook open (file name AlphaMaster.xls) and open a second workbook, is there a way to activate the second workbook without using its file name?

The reason I ask is I need to copy data from many data files, whoes names are different, into the AlphaMaster file.

Each data file will be opened separately, a command button will be pressed in AlphaMaster.xls, and I want to copy and paste the data from the data file to AlphaMaster.xls using a Excel VBA macro.

Any ideas?

Thanks.


No luck finding an answer? You could always try Google.