Free Microsoft Excel 2013 Quick Reference

Excel workbooks in different windows & Fill color?

Q1
Hi, how to make excel workbooks opens in different windows?
When I'm using Word all files opens in different windows and I can close
each window without Word finish.

Q2
How do I get different fill-colors other than those listed in the cell -
format - meny?
I got an english template with light grey-cells, worked all right yesterday,
but today all cells with that color has become light-green.
The light-grey color does not show up in the format meny - Weird!

Q3
It's easy to format a cell with colors depending on values eg., but how do I
cange the entire row color or several cells depending on a cells value in
another row?


Post your answer or comment

comments powered by Disqus
I have two workbooks that are linked and if I open them in the same window
they work together perfectly. However I need to open them in separate windows
so one can be viewed on a separate monitor. When I do this it asks me if I
want to update the links which I do but the relevant cells just show #VALUE!.
Even if I go to Edit/Links and try to Update Values or Change Source even
though it finds the right work book (it is password protected and asks for
the password) the relevant cells still show #VALUE!. Is what I am trying to
do impossible or am I missing something obvious.
If it helps this is the formula when I open them in the same window:
=IF(ISNA(MATCH($D$2-1,'[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)-1),"",OFFSET('[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$C$140,,MATCH($D$2-1,'[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)-1))
And this is the formula when I open them in different windows;
=IF(ISNA(MATCH($D$2-1,'C:Documents and SettingsD
ClarkeDesktop[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)-1),"",OFFSET('C:Documents and SettingsD
ClarkeDesktop[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$C$140,,MATCH($D$2-1,'C:Documents and SettingsD
ClarkeDesktop[BOOKINGS.xls]NOV 2005 - JUNE 2006'!$C$2:$IJ$2,0)-1))
If anyone could help it would be greatly appreciated. Many thanks.

I just want to know which options should be enabled to open different exel
sheets in different windows by opening single Excel application

I have multiple excel files. I want to have them all opened at the same time
in
different windows so I can alt-tab to each of them. I have checked
Tools|Options|View Tab|Check Windows in task bar but I still cant alt tab
over they open in the same button ont he taskbar. Is there a way of doing
this?

Up until last week, whenever I opened separate workbooks, they would always open in separate windows. Now all workbooks always open in the same window. Does anyone know how this might of happened and how I can change it back?

hi. good days,
how can i open a different path of the workbook in the listbox. if my listbox there only show the file name.

Private Sub btn_browse_Click()
Dim FileSelected As Variant
Dim filename
Dim FSO As Object

Set FSO = CreateObject("Scripting.FileSystemObject")
filePathA = Application.GetOpenFilename("Excel Files (*.xls), *.xls")
 
If filePathA = "False" Then
    filePathA = ""
    Else
    With ListBox1
          .AddItem
            .List(.ListCount - 1, 0) = FSO.GetFileName(filePathA)
            .List(.ListCount - 1, 1) = filePathA
        End With

  End If
End Sub
if the workbook in different path, it will show the error. please help me. thanks

For Index1 = 0 To ListBox1.ListCount - 1
      Set wbFrom = Workbooks.Open(ListBox1.List(Index1))
           wb1 = ListBox1.List(Index1)
        Next Index1


Hi,

I was wondering if there is a way to open Excel workbooks in separated
windows. MS Word behaves that way by default. I'm using Office 2000 on
Windows XP Pro.

Thanks in advance.

Regards,
SBH

Knights of the Excel Round Table!, please assist a maiden the following (mis) adventure. I would like a macro that does the following (in Excel 2003):

1. Sets the calculation mode of the workbook in which the macro resides to "Manual".

2. Takes a folder path that I have pasted into the cell of an empty worksheet in the macro workbook and copies down the rows all the names of the excel workbooks in that folder into the blank worksheet. (The folder only contains the excel workbooks to be processed)

3. Goes into each file from that list that has just been copied. Opens it up. Manually Recalculates the whole file (ie hit F9). Ensures that file will be saved in manual recalc mode. Saves the file.

4. Updates a cell adjacent to the workbook name in our macro workbook with the date and time the book was manually refreshed. (EDIT: guess this will just be the time that the wb was saved as saving automatically refreshes?)

Any ideas gratefully received!
x

Hello,

I have created 19 excel workbooks in a directory that are all basically the same. I currently have to open each workbook to refresh the pivot tables and to update the links. Is there a way for me to automatically run the macro in each of the workbooks?

Thank You

Could anyone please help me out as to how we can save the excel workbook in
the database and

read it back.

I was able to convert the text files and image files into binary format and
save them to the

DB and finally able to retrive them back in the same format. But was unable
to do same for

the excel object.

Your help will be greatly appreciated.

Thanks,

regards,
jitender

hi!
Could anyone please help me out as to how we can save the excel workbook in
the database and read it back anytime we want.

I was able to convert the text files and image files into binary format and
save them to the DB and finally able to retrive them back in the same format.
But was unable to do same for the excel object.

Any kind of help will be greatly appreciated.

First, thank you for any help.

I have a co-worker who's excel is a mess. For whatever reason she does not have the standard color palette in excel where you would select fill colors. For example, not the normal yellow, blue, etc. Instead has different shades like a light yellow or turquoise.

To make matters worse when you send her a spreadsheet it can often change the color formatting.

To rule out some items, it seems to only happen in excel and it's not a color issue on the computer.

Any help would be appreciated.

I just put office 2007 on my new laptop for work. I opened an old excel file
created with excel 2003 and noticed my fill colors weren't in the cells I had
put them in. I tried to add fill color. Nothing. I even tried to create a
new worksheet and entered info in a cell, tried fill color -- no dice. Is
there something I'm not doing correctly or is there a glitch in excel 2007?

HI,
Whenever i try to open multiple excel files, They open in a same window. How
to make them open in different windows? Can anyone help me out in this?
Thanks in advance.

Yash

My elderly father uses lots of Excel workbooks for different lists etc, but
with2 or 3 open they all open within '1 Excel program'. Can Excel be set
to open each workbook into its own window rather like Publisher or even
Internet Explorer?

It would enable easier+ more understandable switching between panes and
more importantly closing the prog/ 1 file without saving won't mean he
closes ALL without saving as has been the case- on more than 1 occasion
now..
Using Autosave isn't always the best method either since it then 'freezes'
the file stopping the ability to UNDO

regards
AW

Hello,

I would like to know how to do programming in oreder to get the excel
objects open multi-workbooks. Let me descripe what I need to be done on my
project following this.

I have 3 excel workbooks. For example, A, B, and C.

First, I have A to open. With A, ThisWorkbook_Open(), I have its to open B.
B contains links to a DLL. [Through this my project works well] This step, I
could get all values through the links.

Next, I would like to open C with the same window. That I cannot open it in
the same window with A and B, when I setup window scheduled task.

Please give me suggestion.

March

Hi.

I have two excel workbooks in which named Book1 and Book2.
Book1 needs to be filtered on Quarter and Year. The resultant output has some visible set of records.
In the same workbook - Book1, Column C (Named - ContractId) needs to be compared with Workbook2(named - Book2) with Column A(Named-ModelId).
If any of these Contract Ids after filtering is found in ModelId in anotherworkbook, then some columns values from the respective ModelIds from book2 needs to be copied in some specific columns in Book1.

1. How to match visible cells in 1 column from another column in another workbook.

2. If match found, then how to copy data from another workbook to the current workbook. Columns in these two workbooks have different positioning and different column names.

Any help on this is highly appreciated.
Thanks everyone.

Good Morning! For my first post, I'm going to ask something that's got me stumped. I've looked around and haven't found quite what I need, nor anything kind of close...

I have excel files that are generated from Autocad to a specified folder. I then have to move the sheets in this folder (in 1 or more workbooks) to a master workbook in a different folder. I have to do this a bunch of times for each project (things change and the master needs updating), and I have to do this over multiple projects. Currently, I open up the Autocad-generated WBs and rename the sheet to their filename, then manually move them over to the master WB (deleting any previous sheets that were created by this method). It seems like something fairly simple to do, but my VBA skills are seriously lacking, so I need some guidance.

A couple of notes regarding how this all works:
The file structure varies for each project, so I can't use a hard-coded folder reference, but I can use relative paths. In my case, the master WB is in a directory called "BOM_ItemList", while the Autocad-generated WBs are in a folder called "Misc". Each of these folders are in the same directory (i.e., "BOM_ItemList" and "Misc" are in a folder called "Units".The Autocad-generated WBs are named for the drawings they're produced from, so their filenames vary (although each sheet name is the standard "Sheet1"). However, I don't know that it matters, I need every xl file in that directory.
So I suppose my question is how do I copy all the sheets from all the XL files from the "Misc" directory to the master WB using a relative file paths? I've come across some code (included below) that seems close, but I don't know how to modify it to suit my needs. Any help and/or guidance would be greatly appreciated, as I do this a lot and it's tedious work.


	VB:
	
 
Dim mypath As String 
mypath = ActiveWorkbook.Path & "..misc" 
 
Private Declare Function MeaningOfLife Lib mypath () As Long 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

	VB:
	
 
Sub RunCodeOnAllXLSFiles() 
    Dim lCount As Long 
    Dim wbResults As Workbook 
    Dim wbCodeBook As Workbook 
     
     
    Application.ScreenUpdating = False 
    Application.DisplayAlerts = False 
    Application.EnableEvents = False 
     
    On Error Resume Next 
    Set wbCodeBook = ThisWorkbook 
    With Application.FileSearch 
        .NewSearch 
         'Change path to suit
        .LookIn = ActiveWorkbook.Path & "..misc" 
        .FileType = msoFileTypeExcelWorkbooks 
         'Optional filter with wildcard
         '.Filename = "*.xls"
        If .Execute > 0 Then 'Workbooks in folder
            For lCount = 1 To .FoundFiles.Count 'Loop through all
                 'Open Workbook x and Set a Workbook variable to it
                Set wbResults = Workbooks.Open(Filename:=.FoundFiles(lCount), UpdateLinks:=0) 
                 
                 'DO YOUR CODE HERE
                 
                wbResults.Close SaveChanges:=False 
            Next lCount 
        End If 
    End With 
    On Error Goto 0 
    Application.ScreenUpdating = True 
    Application.DisplayAlerts = True 
    Application.EnableEvents = True 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Someone told me this was the more appropriate location for this question since it may relate to macros.

First, thank you for any help.

I have a co-worker who's excel is a mess. For whatever reason she does not have the standard color palette in excel where you would select fill colors. For example, not the normal yellow, blue, etc. Instead has different shades like a light yellow or turquoise.

To make matters worse when you send her a spreadsheet it can often change the color formatting.

To rule out some items, it seems to only happen in excel and it's not a color issue on the computer.

Any help would be appreciated.

I use two monitors for my laptop. If I launch two instances of Excel, I can
drag one instance to the other monitor and work in two spreadsheets maximized
at one time. My coworker's Excel, on the other hand, opens one instance of
Excel, and all spreadsheets open in the same instance, and are each listed in
the "Windows" menu. So the only way she can view both sheets at one time is
to spread Excel over the length of both monitors and then arrange the windows
side-by-side within the same instance. Looking at previous posts, I thought
the solution was Tools - Options - View - Windows in Taskbar. However, hers
is already checked, the same as mine. In fact, we can't find any settings
that look any different between her setup and mine. Any ideas?

TIA

This is a reply to a question posted by Jason Dove in 2005 (Timestamp = 2005:05-03-2005, 03:06 PM.)

The so-called experts that told him it could not be done and never could are simply wrong.

Solution:
Go to the executable at "C:Program FilesMicrosoft OfficeOFFICE11EXCEL.EXE" and copy it.

Then paste the shortcut directly on the desktop.
Open the first excel file any way you like.
Then drag and drop the 2nd excel file on the new shortcut. It opens in a different window. Sorry you had to wait so long for the answer Jason.

Hi,

i was wondering if the following could be achieved?
i have approx 600 excel books all created from a master template. originally
they were named indiviually as 1234 (job number) & "Quotes & Orders".xls
where later i renamed the template to Quote book giving me job number and
quote book.
example: 1234 Quote Book.xls
the excel books are found in various client folders in 1 parent folder named
"Clients" in my Company Shared folder on my server.
i need to retrieve ALL specific data from ALL of these books and place in
list form in a single book. the data is found as follows in all books:

Client Name = C1
Job No = C2
Description = C3
Project Date = C4
Job Value = E36
Total Spend = E33
Quoted Hrs = L19
Actual Hrs = M19

Can the be achieved? basically, i will need something to look through the
complete folder, filter out all of these books and retrieve the data.

thanks in advance,

Nigel

P.S.

Also included in the parent folder "Clients" are other excel books for
different tasks so i would need to filter the workbooks by "Quote Book" &
"Quotes and orders" if possible. They are all exactly the same with the same
ranges only as detailed above, renamed and specific to different projects.

thanks,

Nigel

Excel workbook worksheet tabs should have 'change color/font' options for
priority visibility. My company uses Excel worksheets as testing templates
in our bio-tech QC laboratory. Some workbooks have multiple worksheet
templates in them and although they are all named, it would be more efficient
to be able to prioritize a worksheet visually by changing that specific
worksheet's tab color to YELLOW or the font to BOLD RED. All our worksheets
tend to look similar and if a technician isn't paying close attention to the
tab name, they sometimes use the wrong one and have to duplicate their work
later.

sorry I didn't know how to search for this.

When ever I open 2 differnt files they open in the same window. I want two different windows of excel so that they are side by side.

How do I get them to open in two seperate excel windows?

Thanks

Hi.

Always in the past when I have created a new Workbook, it opened in a
new Window, separate from the Workbook that was already open. Now, today,
for no reason that I'm aware of, Excel refuses to put the new Workbook in a
separate Window. It puts the new one in the same window, on top of the one
that was already open.

Did I state that clearly?? Do you know what I mean??

I cannot get the new Workbook into its own Window. I can split the
Window, so both Workbooks are visible, but that's not what I want. I want
the new Workbook in its own Window, totally separate from the workbook that
was already open. It has always done that in the past.

Does anybody have any idea why it suddenly refuses to let me have two
windows for two Workbooks?? And how can I correct it??

Thanks,

Sam


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