Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hidden names in active workbook
I have a very simple worksheet in which I am storing data such as name;
company; e-mail address etc. My issue is that after altering the size of some of my cells to accomodate the data and also cutting and pasting info from another spreadsheet, I now have some cells that have e-mail links in cells that do not contain e-mail addresses so a new e-mail message box pops up everytime I click on that box. So it seems as if there is hidden data in the cells that doesn't correspond with what is in the cell or formula box... Has anyone encountered this and can I fix it easily? Thanks! |
#2
|
|||
|
|||
Try this:
1) Use arrow rather than mouse to select the cell 2) Right click mouse (click right button) and a popup window will show 3) Select "Remove hyperlink' Hope this helpful. ===== * ===== * ===== * ===== Daniel CHEN Spreadsheet/VBA Specialist www.Geocities.com/UDQServices Your "Impossible" Task Could Be Someone Else's "Piece of Cake" ===== * ===== * ===== * ===== "hamcdo" wrote in message ... I have a very simple worksheet in which I am storing data such as name; company; e-mail address etc. My issue is that after altering the size of some of my cells to accomodate the data and also cutting and pasting info from another spreadsheet, I now have some cells that have e-mail links in cells that do not contain e-mail addresses so a new e-mail message box pops up everytime I click on that box. So it seems as if there is hidden data in the cells that doesn't correspond with what is in the cell or formula box... Has anyone encountered this and can I fix it easily? Thanks! |
#3
|
|||
|
|||
Thanks - that did work! It will be rather tedious but at least it's a fix
:-). Any idea why this happened? I'd like to avoid repeating my mistake... "Daniel CHEN" wrote: Try this: 1) Use arrow rather than mouse to select the cell 2) Right click mouse (click right button) and a popup window will show 3) Select "Remove hyperlink' Hope this helpful. ===== * ===== * ===== * ===== Daniel CHEN Spreadsheet/VBA Specialist www.Geocities.com/UDQServices Your "Impossible" Task Could Be Someone Else's "Piece of Cake" ===== * ===== * ===== * ===== "hamcdo" wrote in message ... I have a very simple worksheet in which I am storing data such as name; company; e-mail address etc. My issue is that after altering the size of some of my cells to accomodate the data and also cutting and pasting info from another spreadsheet, I now have some cells that have e-mail links in cells that do not contain e-mail addresses so a new e-mail message box pops up everytime I click on that box. So it seems as if there is hidden data in the cells that doesn't correspond with what is in the cell or formula box... Has anyone encountered this and can I fix it easily? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter a customer name in the invoice workbook when the names are . | Excel Worksheet Functions | |||
Hyperlinks With Workbook With Hidden Sheets | Excel Discussion (Misc queries) | |||
How can I Copy cell names from one workbook to another? | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |