Workspace Question - Excel 2002

COgreywolf

New Member
Joined
Jan 22, 2012
Messages
3
I have a workspace that includes 4 workbooks(worksheets) to which I want to add an existing additional workbook(worksheet) that is not currently park of the workspace. I cannot see how to do this. Your help is greatly appreciated.
 

Weazel

Well-known Member
Joined
Dec 24, 2011
Messages
3,155
if I'm understanding it correctly you want to add a new worksheet to an existing workbook....you should be able to either right click on any of the sheet names and select insert, or hold down Shift and tap the F11 key.
 

COgreywolf

New Member
Joined
Jan 22, 2012
Messages
3
No Weasel. I want to add an existing spreadsheet that it is not included in the workspace to this workspace. Let's say worksheets A, B, C and D are the worksheets now in the workspace. I want to add a new worksheet E to the worksheet so that all 5 worksheets will open when I open the workspace. Does that make sense?
 

Weazel

Well-known Member
Joined
Dec 24, 2011
Messages
3,155
Ok, I think I got it now....
To add a new file to the workspace just open it and arrange it however you want it then just resave the workspace with the same file name.
The workspace kind of just builds links to the actual worksheets so just resaving the workspace itself should add the new workbook to it

On the older versions of excel it should be file...save workspace I believe...the newer versions its on the View Tab...Save Workspace.
 
Last edited:

COgreywolf

New Member
Joined
Jan 22, 2012
Messages
3
Thank you. I will copy the existing worksheet to the new one created in my workspace and I'll be good to go. Thanks a lot. The answer was staring me in the face.
 

Forum statistics

Threads
1,081,845
Messages
5,361,663
Members
400,643
Latest member
RockStar89

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top