Question about Business & Productivity Software

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

Excel 2007 document recovery repeating document on Terminal Server


MS Excel File can get corrupted due to virus attack, missing MS office files, power failure and other possible reason that can be fixed by only use Stellar Phoenix Excel Recovery fix corrupt Excel (.XLS/.XLSX) files and restore everything (including charts, chartsheets, cell comments, worksheet properties etc.

Jan 04, 2015 | Microsoft Excel for PC

1 Answer

Excel 2003 worksheet slow in 2007


Hi Lee, I have recently experienced the same thing. When Excel 2007 or later opens an Excel 97-2003 .xls file, there are major issues of speed. The file is opened in compatibility mode. The best thing to do would be to open the file, then save as (keep the same name if you like) an Excel 2007 .xlsx document (or .xlsm document if there are macros). Close the file, then reopen it, and the compatibility mode issue will be gone. You can now use the newly saved file as a normal Excel 2007 file. Hope this helped.

Mar 25, 2014 | Microsoft Office Professional 2007 Full...

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

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

How i can crack the password of excel sheet..............


Hi,

Have tried downloading the password.xla? If not, below is the link:

http://www.straxx.com/excel/password.html

Just add this xla to your addins and then open your excel document. The sheet will be automatically be unprotected.

Feb 09, 2011 | Microsoft Office Professional 2007 Full...

3 Answers

How can I launch without recover.c


Look for the answer here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/653-i-get-a-message-that-the-file-is-damaged-or-corrupted

Or:
XLSX Repair Kit. The latest corrupt XLSX file repair software featuring a powerful data recovery core and a convenient step-by-step wizard for extra convenience.
For more information: http://www.xlsx.repair/

Dec 31, 2009 | Microsoft EXCEL 2004 for Mac

6 Answers

I have forgot my excel password how do i open the sheet


Excel Password Recovery 2009

This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).
This program will remove passwords of any length, also passwords containing special characters.

zipped: password.zip

Mar 06, 2009 | Microsoft Word 2000 for PC

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?
Business & Productivity Software Logo

Related Topics:

101 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...