Removing "Foreign" objects from Excel notebook file?

In summary, the conversation discusses a problem with a picture-like object in an Excel file that cannot be deleted, as well as the benefits of using a newer version of Excel. The conversation also mentions a British company called Pivigo and asks if the other person has heard of it.
  • #1

WWGD

Science Advisor
Gold Member
6,724
9,671
TL;DR Summary
Having trouble deleting "Foreign Object" picture-like from an Excel 2007 file.
Hi,
I'm having trouble dealing a "picture-like" object that I copied from a webpage (.html) file. It is the larger white rectangle in rows 194-195, that reads "United StatesStates"
IMG_20211209_190407_01.jpg

It just doesn't go away when I delet the the row. I tried to scrape the file directly into Excel from the site , but got a '403' error message (forbidden). How can I delete the row without affecting other files?
Thanks.
 
Computer science news on Phys.org
  • #2
Try clicking on the picture and hitting delete.

Office 365 Family at GBP80 a year (not sure how much it is in US) is worth every penny to me.
 
  • #3
pbuk said:
Try clicking on the picture and hitting delete.

Office 365 Family at GBP80 a year (not sure how much it is in US) is worth every penny to me.
Thank you, though I'm not sure I understand you. I'm using Excel 2007. You mean the newer versions
will (more likely) have a way of addressing this issue? And, sorry, r-clicking did not work. I just copied all previous rows into a new sheet. Hey, can't overdo the practice of data cleaning.

On a separate note, any chance you've heard of this British company Pivigo? Have you heard anything about it?
 
  • #4
WWGD said:
Thank you, though I'm not sure I understand you. I'm using Excel 2007. You mean the newer versions
will (more likely) have a way of addressing this issue?
Probably not, but newer versions play a LOT better with all kinds of connections, as well as do a lot of other stuff better. If you are at all serious about data science (or anything really) on Excel you need to be on the current version.

WWGD said:
And, sorry, r-clicking did not work. I just copied all previous rows into a new sheet. Hey, can't overdo the practice of data cleaning.
Glad you got it sorted.

WWGD said:
On a separate note, any chance you've heard of this British company Pivigo? Have you heard anything about it?
Yes, haven't worked with them personally but I know they are doing stuff with clients I know. Looks like there was some corporate finance activity this Spring.
 

1. How can I remove a specific object from an Excel notebook file?

There are a few ways to remove a specific object from an Excel notebook file. One option is to right-click on the object and select "Cut" or "Delete." Another option is to select the object and press the "Delete" key on your keyboard. You can also use the "Find and Replace" feature to search for and remove specific objects.

2. How do I remove all foreign objects from an Excel notebook file?

To remove all foreign objects from an Excel notebook file, you can use the "Find and Replace" feature to search for and delete all objects. You can also use the "Select Objects" tool to select and delete multiple objects at once. Another option is to use a macro or VBA code to remove all objects from the file.

3. Can I remove objects without affecting the data in my Excel notebook file?

Yes, you can remove objects without affecting the data in your Excel notebook file. Objects such as charts, shapes, and images are separate from the data in your file and can be deleted without affecting the data. However, make sure to save a backup of your file before making any changes.

4. How do I prevent foreign objects from being added to my Excel notebook file?

To prevent foreign objects from being added to your Excel notebook file, you can use the "Protect Workbook" feature to restrict users from inserting objects. You can also use the "Review" tab to track changes and prevent unauthorized changes to your file. Additionally, regularly saving a backup of your file can help prevent unwanted objects from being added.

5. Can I remove objects from an Excel notebook file on a mobile device?

Yes, you can remove objects from an Excel notebook file on a mobile device. Most mobile versions of Excel have the same features as the desktop version, such as the ability to select and delete objects. However, the process may be slightly different depending on the device and the version of Excel you are using.

Suggested for: Removing "Foreign" objects from Excel notebook file?

"Allow editing" absent in sent EXCEL file
Replies
13
Views
819
Unexpected behavior in Excel when sorting
Replies
7
Views
326
Fixing Annoying Word/Excel Windows Problem
Replies
3
Views
1K
Shrinking file size for picture (.jpeg)
Replies
27
Views
1K
Data transfer from MS Excel to PSPP
Replies
16
Views
2K
Microsoft Excel background grid color default reverts
Replies
10
Views
976
Need To Do Fancy Windows File Manipulation
Replies
5
Views
879
Dashcam is leaving file artifacts on SD card
2
Replies
35
Views
2K
Removing "Thingy" from my Taskbar
Replies
20
Views
1K
Excel/Google Sheets REGEXMATCH
Replies
2
Views
820

Hot Threads

Recent Insights

Back
Top