Question about Computers & Internet

1 Answer

Deleting file from Excel also from recently created documents.

Iwant to completely remove a file from Excel. When I try to open it up it says it has been removed, deleated etc. but it still shows in Excel's history.

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 728 Answers

Hi jv_oberg,

The recent documents area of excel is just a snapshot of what it last opened, it's not really linked that document to excel. Eventually, after you open enough documents it will fall off the list. However, if it something that you would like to change, you can

  1. Click on Office button, and then click on Word Options (in Word 2007) or Excel Options (in Excel 2007) or PowerPoint Options (in PowerPoint 2007) in the bottom of Office Menu.
  2. Go to the Advanced tab.
  3. Scroll down to the Display section.
  4. Set the value for Show this number of Recent Documents: to 0 (zero). deleting file from Excel also from recently create - no-of-recent-docs.jpg
  5. Click OK button.
  6. Repeat steps above again, and set back the value for the number of Recent Documents to show to its original default, i.e. 17. If you don’t want this particular Office 2007 application to remember any Recent Documents, you can leave the value at 0 and skip this step.


That will clear your recent documents.

Good Luck,

Mark

Don't forget to leave a rating!

Thanks

Posted on Jan 06, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How to recover Excel lost file


How to solve some troubles with excel files you may learn from- http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/481-%E2%80%8Bexcel-files-corrupted

How to Recover an Excel File for Free

1.Check the Recycle Bin--if you've accidentally deleted the file, it should still be there unless you've emptied the bin, and you can click on the file and recover it.

2.Use the Auto Recovery Pane when you open Excel. Review the document recovery pane. If Excel has managed to recover your file, it will show in a separate pane on the left-hand side. Identify your document in the pane, then click on it and choose "Open" to open the recovered file.

3.Try manually repairing the file. Click on "File" in Excel 2003 or the "Office" button in
Excel 2007, then select "Open" and click on the arrow next to the "Open" button. Click on
"Open and Repair" and choose from two options: click on "Repair" if you want to try to completely recover the file, or click on "Extract Data" if you previously tried Step 1 and it did not work.

4.Search for the file manually on your computer. When performing a system search (click "Start" and select "Search" in Windows XP and Windows 2000, or press the "Windows" button and "F" key in Windows 7 and Vista), make sure you choose "Advanced Search Options" and then check the "System and hidden files" check box. You may be able to find your missing or corrupted file using this search: double-click on the file name in the search results to open it.

If nothing can help you, look at Excel Repair Toolbox

As a solution, it costs money, but effective- http://www.excelrepairtoolbox.com/

Nov 11, 2014 | Microsoft OFFICE 2013 PROFESSIONAL 1 PC...

Tip

How to recover Excel 2007 password


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password
Set a password to open Excel 2007
  • 1. Click the Microsoft Office Button 3dac3a8.gif, point to Prepare, and then click Encrypt Document
  • fd07008.gif
  • 2. In the Password box, type a password, and then click OK.
  • You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  • 3. In the Reenter password box, type the password again, and then click OK.
  • 4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet
  • In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  • 1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  • 2. On the Tools menu, click General Options. The General Options dialog opens.
  • 3. Under File sharing, in the Password to modify box, type a password.
  • 4. In the Confirm Password dialog, re-type the password. Click OK.
  • 5. Click Save.
Remove password protection from an Excel spreadsheet
  • 1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  • 2. Click the Microsoft Office Button 3dac3a8.gif , point to Prepare, and then click Encrypt Document.
  • 245e5bd.gif
  • 3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  • 4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007

on Jun 09, 2010 | Audio Players & Recorders

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | Computers & Internet

1 Answer

Hyperlink other document in excel button


The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

Feb 21, 2014 | Microsoft Excel for PC

1 Answer

Windows 7 program windows xl wont open file


Are you using the same version of Microsoft Excel that you created the file with? If you created in in a newer version, then open it in the newer version, and go File > Save as.. and save it as an older version of the excel document, that is backwards-compatible.

Feb 25, 2013 | ASUS Computers & Internet

Tip

Microsoft Excel tips


Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

on Dec 27, 2009 | Computers & Internet

5 Answers

Excel sheet has been lost how to recover


Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...

1 Answer

Printer almost always refuses to print Landscape from Excel. It prints Landscape or Portrait from other software, but balks with Excel in Landscape. It prints a portion (the information at the left) in...


Try printing to a different printer if possible. This may shed some light on whether the problem is with the printer or with Excel. You could also open the file on a completely different PC and printer to see if something is corrupt in the file. Also try creating a completely new document to see if it will print in landscape. Can you print in landscape orientation from MS Word or another program?

Jul 18, 2011 | Office Equipment & Supplies

3 Answers

Microsoft Excel Temp Files


I just finished with Trend Micro help support and they solved this problem for me. Open the main console for Trend Micro. Click on Viruses & Spyware Controls. Click on the "settings" for Protection Against Viruses & Spyware. Click on Advanced Settings. Under the section for "What Should TMIS Check for Threats" click on the circle for "Specify Targets that you choose". Click on "Select" next to "Ignore Specific Files & Folders". Then Add and folders of files that you do not want Trend Micro to check and make backups for. That solved my issue...hope it helps you too.

Oct 29, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

101 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...