Excel 2010 :: Can't Paste From One Instance To Another

Jul 2, 2014

I am running Excel 2010. I have two separate instances of Excel running. I select data and copy it, and then paste it into the other excel spreadsheet in a separate instance. The clipboard data DOES NOT paste the desired data, instead it pastes the item most recently copied in the separate Excel instance that I am trying to paste into. It's as if the excel instance has it's own clipboard, and is unable to use the same clipboard the other Excel instance is using. Copy and paste functions / clipboard seems to working perfectly outside of the Excel program.

View 4 Replies


ADVERTISEMENT

Excel 2010 :: Opens New Instance For Each Fie

Dec 12, 2012

In the last couple of weeks my copy of Excel 2010 has started acting strange. Now when I double click an xls or xlsx file in Windows Explorer, it tries to open a new instance of Excel, whic means that it tries to reopen Personal.xlsm and Personal.xlsb, and finds they are already open, so it gives me an error message. Previously it perfectly happily opened the document in another window in the same instance, which is presumably much more memory efficient quite apart from the file locking problem mentioned. How do I get it back to the way it was before? Is this another of MS's famous overnight downgrades?

View 2 Replies View Related

Excel 2010 :: Cut / Paste Jumps To The Top Of The Spreadsheet?

May 23, 2013

I have a system running Windows 7 Professional (32 bit) and MS Office 2010.

In Excel 2010, I have a spreadsheet that contains several hundred rows of data. When I cut and paste a section of data, Excel jumps to the top of the spreadsheet. This does not happen when I copy/paste, just cut/paste.

View 1 Replies View Related

Excel 2010 :: Paste To Visible Cells Only

Mar 15, 2014

I'm using Microsoft 2010 and as like many others here I cannot find a way to paste into visible cells only i.e. the data I want to add to my variables is only available for every five years, but my data ranges 1990-2010 each year, so I have filtered my data to the 1990,1995,2000,2005,2010 so that I can paste the new data in, but of course it pastes into 1991 1992 1993 etc instead of the filtered results.

I've tried the find and select visible cells only but it says when you try and paste into them that it is not possible for more than one cell at a time.

View 7 Replies View Related

Excel 2010 :: Paste Special Options Not Available

Apr 9, 2012

I am using excel 2010 and cant see the paste special options in any of the worksheets. If I restart my laptop then it shows up. I noticed that after opening Internet explorer, the options disappear once again and restarting the system brings them back.

View 1 Replies View Related

Excel 2010 :: Copy And Paste Function?

Apr 18, 2012

The problem is that whenever I have any browser open, IE, Chrome, Firefox, etc... the Cut & Paste, Copy & Paste function does not work correctly in Excel 2010.

When I Cut or Copy the blinking marquee around my selection briefly appears and then disappears. When I try to paste, I only have two options under the paste special function: Unicode Text and Text, same with cut and paste, however, the text doesn't actually cut, it only copies.

As soon as I close down any of the mentioned browsers, the full functionality of the cut/copy & paste functions are restored, no need to restart excel.

I need to have open a browser most of the time for work as our system is web based, so closing and re-opening is more than just an annoyance.

View 2 Replies View Related

Excel 2010 :: Paste New Data In First Empty Row

May 30, 2012

I have the following macro that imports a copy of data into a worksheet. I would like it to paste the data below in first empty row (where column A is empty) instead of A1. I am using Excel 2010.

Sub Update ()

' Import_New_data
'
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy

[Code]....

View 2 Replies View Related

Excel 2010 :: Getting Simple Macro For Paste Value

Oct 21, 2012

Need a simple macro for paste value - it used to work in Excel 2003 but not 2010.

View 1 Replies View Related

Excel 2010 :: VBA Macro - Paste Special Values

Nov 9, 2012

Not sure if it's me or a new change in excel 2010, yet creating a simple macro as listed below does not work.

Outside of macro I will select a range of data and copy.

Then, using macro I'd like i to perform: paste special values, in the current cell

View 5 Replies View Related

Excel 2010 :: Copy And Paste INDIRECT Formula?

Aug 2, 2013

I'm working in Excel 2010 on a sheet that will be compiling data from a different worksheet based on the current month. I'm using the formula:

=IF(INDIRECT($K$7&"!C45")>"",INDIRECT($K$7&"!C45"),"")

to complete the field using the other sheets value if it's not empty, where $K$7 references a worksheet name based on the previous month.

It's working just fine, but I want to copy and paste it into other cells having the referenced cell, C45, change as I move it around the sheet (if I copy and paste it 3 cells to the right it would become =IF(INDIRECT($K$7&"!C48")>"",INDIRECT($K$7&"!C48"),"").

I haven't been able to find a way to make the C45 cell reference dynamic while copying and pasting. It would save me a ton of time if I could.

View 3 Replies View Related

Excel 2010 :: Paste URL As Hyperlink Or Format Existing URLs

May 16, 2013

Using excel 2010 on PC.

Paste URL as Hyperlink: I just want to paste a bunch of urls into a spreadsheet and have them automatically formatted as urls. i've checked my auto-correct options, and i have selected the checkbox that says: replace as you type/internet and network paths with hyperlinks.

See attached. if you copy and paste a url into the spreadsheet, it will be formatted as text.

Format Existing URLs as Hyperlinks : the attached spreadsheet contains urls that have been copy & pasted. is there a way to format them as hyperlinks all at once?

View 1 Replies View Related

Excel 2010 :: How To Move The Paste Options (Ctrl) Popup Box

Apr 19, 2012

When I copy a cell with CTRL-C and paste elsewhere, a small clipboard pop-up appears to give paste options. The pop-up is the size of an average 'starter' cell. I find it a nuisance as it always covers a cell I might want to paste into, but I cannot see that cell anymore because of the pop-up. How can I get rid of the pop-up?

View 2 Replies View Related

Excel 2010 :: Copy And Paste Cells Within Date Range

Mar 27, 2014

I have on sheet "Charts" in cell "B20" a "date from" and in cell "C20" a "date to" (these will be input manually).

What I need is to check Column "F" on sheet "Report" for any cells within those dates, I then want to copy the entire row(s) that contain these dates and paste them into sheet "Weekly" starting at cell "A2".

Using excel 2010

View 4 Replies View Related

Excel 2010 :: Retrieve Photo From A Folder And Paste It Into Cell

Apr 20, 2014

Excel 2010, Windows 8.1. I want to retrieve a photo from a folder and paste it into a cell. I have the paste and format process figured out but I'm having trouble putting the file path together to retrieve the photo. If I use the full path, the statement below retrieves "IMAG1234.jpg" and puts it where I want it.

ActSheet.Pictures.Insert("C:UsersEljafeDocuments1-QCReport_PhotosIMAG1234.jpg").Select

But if I have a different photo file name as a string in a cell (e.g. "IMAG5678.jpg") what is the syntax to attach it to the file path? i.e

ActSheet.Pictures.Insert("C:UsersEljafeDocuments1-QCReport_Photos") & "IMAG5678.jpg".Select '(which of course doesn't work)

So, I have a path but I want to attach different photo number to the path from a sting in a cell.

View 2 Replies View Related

Excel 2010 :: Pivot Table Copy And Paste Values AND Formatting

Jun 13, 2014

In excel 2010, I'm using the following to copy and paste values and formatting from a pivot table, but i lose the formatting (TableStyle2 = "PivotStyleLight8"):

VB:
Selection.CurrentRegion.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

I have tried to add, xlPasteFormats, but to no avail...?

View 4 Replies View Related

Excel 2010 :: Paste Options No Longer Showing Up When Clicking CTRL

Jul 30, 2014

I'm currently using Excel 2010. Before, when ctrl+v'ing a cell that wasn't a number (but was, for example, a function), I could immediately after press ctrl, bring up a paste menu, and press v to paste as a value.

So before, if I had a range of cells that were functions (say something simple like "=D3/E3" on F3 and dragged down), I could do the following to paste the range into another worksheet:

1. Ctrl+shift+down to select the entire range
2. Ctrl+C
3. Ctrl+V into a different worksheet (at which point everything shows up as either "#DIV/0!" or as the wrong number, depending on cells to the left)
4. Ctrl (brings up the paste menu)
5. V (selects "values")
6. The entire range is now pasted as values, and not as functions

Recently, however, clicking on "ctrl" after pasting brings up no paste menu. I haven't changed any settings. I will lovingly serenade the first (and second, and third) man (or woman) that figure out what settings I must change or what I must do differently.

View 1 Replies View Related

Excel 2010 :: Worksheet Move / Copy Function And Paste Special / Columns Widths

Mar 18, 2014

I am trying to copy one worksheet using the "move/copy" function that is available when you right click a tab name and want to copy the worksheet in the same workbook

The steps I'm using are:

1. Right click the tab name
2. Select Move or Copy,
3. Select Create a Copy
4. Click OK

Doing all of the above does not work. When the new worksheet opens, all columns are the same width. It seems to be stuck on "autofit column width" setting of 8.5. The original worksheet is several columns wide all with different width settings.

I've also used Copy, Paste Special and selected column widths and that does not work either.

View 3 Replies View Related

Subtract First Instance Of Data From Last Instance In Columns

Mar 7, 2014

I need a formula in Column E to find the results for Column E or subtract A2 from C3, C3 from D3, A4 from C3, B5 from D5 and A6 from D6 .

table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;

[Code]....

View 5 Replies View Related

Multiple Instance Of Excel

Feb 5, 2010

I am working on an application for a monthly sports tournament that I run. There are three workbooks to this application: the Administration workbook, the Bracket workbook, and the Leaderboard workbook. I currently have a dual monitor setup (extended, not clone) with my laptop in front of me and a large TV on the wall for the players to see.

In order for the players to see the bracket and the leaderboard, I open excel, then I open the Bracket.xlsm workbook, then the Leaderboard.xlsm workbook, and I drag those to the TV. I then open another instance of excel on my laptop, and open the Administration workbook. This stays on my laptop and the players cannot see it.

Here's what I want it to do:

In less words, the administration workbook controls the other two workbooks. Every time a player reports a win/loss, I enter that into the Administration workbook, and that needs to update both the bracket and the leaderboard, so the players can see it on the TV. So, basically, all the data is in the administration workbook, and the other two serve as displays for that data in a format the players can understand.

Here's my problem:

When I run a macro that is supposed to update the other two workbooks, I get an error: "Runtime Error '9': Subscript out of range." I believe this is because of the seperate instances of Excel. Since Bracket and Leaderboard are in a different instance than Administration, it can't 'see' those other two workbooks. Below is the part of the code that deals with these three workbooks: ....

View 9 Replies View Related

Excel 2003 :: Return Last Instance?

Jan 3, 2012

I have tried Index/Match but nothing so far. Basically, I have this table:

Sheet2KLMN3Employee1Client Assistance/Request31/3/2012 14:57:344Employee1Client Assistance/Request31/3/2012 14:58:075Employee2Client Assistance/Request11/3/2012 14:59:456Employee3Client Assistance/Request11/3/2012 17:08:297Employee1Client Assistance/Request61/3/2012 17:10:16Excel 2003

So now, I want E19 of the table below to bring back column N of sheet 1, but only the last instance in which those Employee 1 and Client Assistance/Request met. In this example N7 of Sheet 2.

Sheet1BCDE18Client Assistance/RequestDate19Employee 10020Employee200Excel 2003

View 5 Replies View Related

Close Open Instance Of Excel

Aug 6, 2013

I use the following code to open an existing open workbook in a new instance of Excel...

Everything works fine... What I would like to do is close (when I say close I mean, completely exit/quit the application). I'm not able to do that, the original Excel instance stays open with no spreadsheet open. I would just like it force the application to quit so that after running the code I would just have one Excel instance open (with the desired workbook, which works fine now)...

Public Sub Re_open_workbook()
Application.DisplayAlerts = False
ThisWorkbook.Save

[Code].....

View 1 Replies View Related

Can't Find File In Another Instance Of Excel

Oct 27, 2013

I have a workbook in instance1 named Workbook1 that can successfully refer to and open a file named data.txt in C:

I have a workbook in instance2 named Workbook2 that can't find the same data.txt file in C:

Why can one instance find the text file but the other can't? How do I work around this issue?

Note: Workbook1 and workbook2 are identical except for their name

Note: Both workbooks are confirmed to be in (and are isolated in) their respective instances

View 1 Replies View Related

Last Instance In Range Excel Cell Location...

Sep 2, 2009

I just used the excellent formula =row(index(range,match(1,index,--(range)>0),0),0))) to give me the first instance of a number, but i am wondering if there is a formula to give me the last instance of the number as well? Maybe? This would save me much time if possible.

View 11 Replies View Related

Excel 2007 :: How To Open Workbooks In Same Instance

Nov 12, 2013

Had to rebuild my PC's hard disk and reinstall software. Now, whenever I open another workbook via explorer double click, a new instance of Excel starts. If I open another workbook using Excel's menu open, then the workbook opens in the same instance. I've tried a 'Repair' of Office and resetting the default programs to Excel for all Excel related file extension types.

View 5 Replies View Related

Setting To Open Files In New Instance Of Excel?

Jan 10, 2011

I would really like excel to open files in a new instance of excel by default. Currently the only way I can do this is by starting excel and then File->Open. While this is only a little bit of extra effort, I've recently gotten in the habit of opening and closing 100s csv files daily and the wasted time really adds up. I've read several threads here, but mostly found people trying to accomplish the opposite of what I am.

View 4 Replies View Related

Excel 2010 :: Paste Picture Into Small Picture / Diagram Box?

Mar 19, 2012

In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?

View 1 Replies View Related

Excel Has No String Search Function With Instance Choice?

Nov 4, 2012

I don't have to keep using the ridiculous Substitute() work-around when I need to grab cell text after the nth instance of a character. In doing data cleanup I'm constantly having to grab text between, say, the 4th space character and the 6th one. Since Search() doesn't have an instance parameter, I end up having to use the 'Substitute trick', since it's the only string function that does have one.

See below for a typical example of the convoluted formula I need, and another example of it if Search only had 'instance' available. Simplifies the formula quite a bit.

*Typical real example, here to find the word between the 4th and 5th spaces in A1:

"=MID(A1, SEARCH("^", SUBSTITUTE(A1, " ", "^", 4)),
SEARCH("^", SUBSTITUTE(A1, " ", "^", 5))-SEARCH("^", SUBSTITUTE(A1, " ", "^", 4)))

Fantasy, 'fixed' example after MS adds instance:
=MID(a1, SEARCH(" ", a1, [instance #4]), SEARCH(" ", a1, [instance # 5])-SEARCH(" ", a1, [instance # 4]))

View 9 Replies View Related

Move Workbooks To New Instance Of Excel By Click Of Button?

Sep 5, 2013

I am looking for a way to move workbooks to a new instance of excel by the click of a button. For example if I have multiple workbooks open under one instance of excel I do not want to have to minimize this and that... I have multiple monitors and I would like to hit a button on a selected workbook and have it auto open it to a new instance of excel. I image this may not be apart of excel and that it might require a macro to do so.

View 1 Replies View Related

Excel Conditional Formatting - Highlight Second Instance Of Combination

Oct 3, 2013

I need a conditional formatting formula that will highlight the second instance of a combination of values from two columns.

For example, Column A is a person's name and Column B is a drop down with 3 options (Street Address, Phone Number, and Email Address). If Row 2 says John Smith (Column A) and Street Address (Column B) and Row 6 also says John Smith (Column A) and Street Address (Column B), what conditional formatting formula would I use to highlight Row 6 as duplicate information?

Name
Information

John Smith
Street Address

Mary Black
Email Address

[Code] ..........

View 2 Replies View Related

Force Single Instance Of Excel When Opening New Workbook From Email?

Aug 28, 2013

I have multiple buyers that use an Excel workbook containing several macros to perform edits on other workbooks they receive via email. Generally, they have the workbook containing the macros open, and they can double-click the workbooks they receive in the email messages to open them, and the macros are available from the "master" workbook.

Recently, however, some of the buyers have been getting new computers running Windows 8 and Office 10. Now when they have the "master" workbook open, and double-click the attached workbook in an email, (Outlook 10), the new workbook opens in a new instance of Excel, and as a result the macros are not available to run on the newly opened workbook.

The work around has been to right-click the attachment and save it to their desktop, and then use the File/Open command from the "master" to open the new file. This is a hassle and takes extra time.

I'm sure I am overlooking a setting somewhere that tells Excel to always open new workbooks using the same instance of Excel, (there are two people using the new systems that aren't having problems, and two that are), but for the life of me I can't find where to set these parameters.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved