Pages

Search

Excel Help Forum - Excel General: forgotten password

Feed2Mail notification - new post on Excel Help Forum - Excel General
forgotten password
hi guys, if i have forgotten the password to a protected sheet is there anything i can do to unprotect it?

Excel Help Forum - Excel Charting & Pivots: Pivot Table to display 'real' data not count - Help Please

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Pivot Table to display 'real' data not count - Help Please
Hi All, I have a challenge with the data that I wish to display in a pivot table. I've searched hard and can see that it may not be possible but worth a try anyway. Basically I want to display a list of jobs that each project manager has to complete within a specific month based on a set of...

Excel Help Forum - Excel Programming / VBA / Macros: Clear various cells in worksheet when changing related cells

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Clear various cells in worksheet when changing related cells
Hi, I have created 4 conditional drop down lists on a worksheet. Upon changing a cell in column S, I need the related column T to be cleared. This is to ensure that the user chooses a relevant item from the list in column T once he/she changes column S. The related cells are S15:T15, S19:T19,...

Excel Help Forum - Excel General: Show the images based on the selective cell value

Feed2Mail notification - new post on Excel Help Forum - Excel General
Show the images based on the selective cell value
Dear experts, I have Equipment list with photos in sheet 1, In "HK-Cl Machineries" sheet when I select B column cell the image should shows in top of the black shaded area.Pls provide the code for this thread.For your reference pls find the attached sample sheet..

Excel IT Pro Discussions Forum: Cannot delete excel 2010 It is being used by another person or program

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Cannot delete excel 2010 It is being used by another person or program

Cannot delete excel 2010  It is being used by another person or program

This is an issue for 2010 shared Excel files, they either open as Read-only or "locking the file" when user not actually within the files but this has only been an issue for her since the upgrade to office 2010.

1)I have cleared temp files and tested but this is still an issue
2)My computer>manage>open files >there is no open files from user and no sessions from user.

3)Please note share drive is on SAN not on file server or locally. If we copy the file from share drive to terminal server it works fine

4)in share drive we cannot rename the file and cannot rename the extinctions like .xls xlsx,xlsm etc..

5)Tried to repair the excel no luck to resolve ,workaround advised saveas the file ,There is no proper Microsoft articles to resolve this issue .please let me know if any

Excel Help Forum - Excel Programming / VBA / Macros: Excel ask every time for outlook profile

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Excel ask every time for outlook profile
Every time i start this code, Outlook is asking for a profile. what do i wrong? if i start outlook first, then there are no questions, but a'm not be able to start everytime outlook first, so this code has to find the profile by itself.. Code: Application.ScreenUpdating = True Dim OutApp As...

Excel Help Forum - Excel General: I can't run macro when I protect the worksheet

Feed2Mail notification - new post on Excel Help Forum - Excel General
I can't run macro when I protect the worksheet
I am sorry if my English is poor. I unlocked cells in the area that macro will use for calculation. When I protect the worksheet the macro could not run. But when I unprotect the worksheet the macro can run again. I want to know how to protect some cells in the worksheet and also enable the...