Copy But Unable to Paste within a Excel Worksheet
I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?
I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub
This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list (as if you manually clicked "Calculate Now" on the Formulas bar) so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that are specifically using the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.
worksheet-function microsoft-excel-2007 copy-paste power-query
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
add a comment |
I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?
I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub
This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list (as if you manually clicked "Calculate Now" on the Formulas bar) so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that are specifically using the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.
worksheet-function microsoft-excel-2007 copy-paste power-query
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
– teylyn
Feb 13 at 22:50
Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cellA1, type Ctrl+C, click in cellB1, …, and then what?)? If possible, post images (screenshots or photographs) in addition to a verbal description. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 14 at 0:10
Are the worksheets or the workbook protected?
– Twisty Impersonator
Feb 14 at 2:02
No the worksheets and workbook are not protected.
– Terra McKinney
Feb 14 at 22:20
add a comment |
I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?
I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub
This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list (as if you manually clicked "Calculate Now" on the Formulas bar) so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that are specifically using the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.
worksheet-function microsoft-excel-2007 copy-paste power-query
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?
I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub
This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list (as if you manually clicked "Calculate Now" on the Formulas bar) so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that are specifically using the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.
worksheet-function microsoft-excel-2007 copy-paste power-query
worksheet-function microsoft-excel-2007 copy-paste power-query
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
edited Feb 14 at 22:32
Terra McKinney
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
asked Feb 13 at 22:17
Terra McKinneyTerra McKinney
12
12
Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
– teylyn
Feb 13 at 22:50
Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cellA1, type Ctrl+C, click in cellB1, …, and then what?)? If possible, post images (screenshots or photographs) in addition to a verbal description. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 14 at 0:10
Are the worksheets or the workbook protected?
– Twisty Impersonator
Feb 14 at 2:02
No the worksheets and workbook are not protected.
– Terra McKinney
Feb 14 at 22:20
add a comment |
Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
– teylyn
Feb 13 at 22:50
Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cellA1, type Ctrl+C, click in cellB1, …, and then what?)? If possible, post images (screenshots or photographs) in addition to a verbal description. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 14 at 0:10
Are the worksheets or the workbook protected?
– Twisty Impersonator
Feb 14 at 2:02
No the worksheets and workbook are not protected.
– Terra McKinney
Feb 14 at 22:20
Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
– teylyn
Feb 13 at 22:50
Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
– teylyn
Feb 13 at 22:50
Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cell
A1, type Ctrl+C, click in cell B1, …, and then what?)? If possible, post images (screenshots or photographs) in addition to a verbal description. Please do not respond in comments; edit your question to make it clearer and more complete.– Scott
Feb 14 at 0:10
Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cell
A1, type Ctrl+C, click in cell B1, …, and then what?)? If possible, post images (screenshots or photographs) in addition to a verbal description. Please do not respond in comments; edit your question to make it clearer and more complete.– Scott
Feb 14 at 0:10
Are the worksheets or the workbook protected?
– Twisty Impersonator
Feb 14 at 2:02
Are the worksheets or the workbook protected?
– Twisty Impersonator
Feb 14 at 2:02
No the worksheets and workbook are not protected.
– Terra McKinney
Feb 14 at 22:20
No the worksheets and workbook are not protected.
– Terra McKinney
Feb 14 at 22:20
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405470%2fcopy-but-unable-to-paste-within-a-excel-worksheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405470%2fcopy-but-unable-to-paste-within-a-excel-worksheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Excel 2007 and Power Query?? Can you be a bit more specific about the searchable list? It is totally not clear what you have on your spreadsheets. Edit your question to provide more detail, then post a comment. Again, edit your question. Do not put the details into comments.
– teylyn
Feb 13 at 22:50
Can you take a simple example of the problem (e.g., copying one cell) and give us an exact description of what you do (e.g., click in cell
A1, type Ctrl+C, click in cellB1, …, and then what?)? If possible, post images (screenshots or photographs) in addition to a verbal description. Please do not respond in comments; edit your question to make it clearer and more complete.– Scott
Feb 14 at 0:10
Are the worksheets or the workbook protected?
– Twisty Impersonator
Feb 14 at 2:02
No the worksheets and workbook are not protected.
– Terra McKinney
Feb 14 at 22:20