Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2010 "Refresh" blocking data

Status
Not open for further replies.
Jomama46

Jomama46

Technical User
Apr 15, 2003
325
0
0
US
I have a spreadsheet that has a picture of the word "Refresh" centered over Row 1 and Columns A and B. It is functional but I don't want it there and cant get rid of it.If I scroll down it stays in the same place on the sheet. If I insert a few lines in the sheet so I can see the data in rows 1-3, the "Refresh" block moves with the rows, still hiding the data. If I Scroll over it and cut or copy, the Refresh doesn't copy.
How can I get rid of this.

pc.gif

Jomama
 
Sort by date Sort by votes
Hi,

"It is functional."

Exactly what does that mean?

Does your Excel workbook have macros?
 
Upvote 0 Downvote
Functional" as in, if I click on it, move inward as if simulating a button press and it will Refresh the screen.
Macros are disabled.

pc.gif

Jomama
 
Upvote 0 Downvote
I have seen this before and I haven't been able to delete the button. What I was able to do was highlight the button and then do a cut and then save the file without pasting.
 
Upvote 0 Downvote
Thanks but I can't get the context menu with a right click for cut and the tool bar "cut" doesn't do it either. Its as if it isnt art of the worksheet.

pc.gif

Jomama
 
Upvote 0 Downvote
It sounds like you have an image that is, or was once, connected to a macro. If you right-click, does that select the picture?
If so, try this:
[ol]
[li]Right-click the image[/li]
[li]Left-click somewhere else in Excel, as long as it's not in the worksheet (title bar, blank part of the ribbon, etc)- this should hide the context menu but leave the image selected[/li]
[li]Press Delete on the keyboard to delete it[/li]
[/ol]
 
Upvote 0 Downvote
right click will not bring up a context menu

pc.gif

Jomama
 
Upvote 0 Downvote
so what I did was scroll over the whole worksheet to select, then copy and paste into a fresh sheet and the refresh didnt come with it So problem gone. thx for all the help

pc.gif

Jomama
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ladyck3
  • Locked
  • Question
Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2
Replies
4
Views
93
ladyck3
ladyck3
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
141
combo
combo
ladyck3
  • Locked
  • Question
Excel 365: [SOLVED ]Data Dump Date: "Jul 12 20:27:14 CDT 2022" convert to 07/12/2022 2
Replies
8
Views
79
ladyck3
ladyck3
Bijugate
  • Question
Excel update question
Replies
0
Views
97
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo

Part and Inventory Search

Sponsor

Back
Top