Question about Excel Computers & Internet
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.
Posted on Jan 02, 2017
SOURCE: average handle time
I have created a spreadsheet for you to a) use and b) to learn from.
It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.
It also allows you to calculate a Part Month average.
I have displayed it as it was CONSTRUCTED and as it would be USED.
The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.
To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.
All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.
The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.
You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).
I have uploaded the file to here:
Hope this gives you the push to really start using Excel.
Posted on Apr 08, 2008
If you have linked one workbook to only one other workbook, I would suggest opening both. This should cause the main one to update basically instantly, and eliminate the timing issue. Otherwise, you might try looking at possibly storing both files in the same folder - it could help. Additionally, depending on what you want the sheet to do, you could set it to update only when you tell it to, rather than automatically - this allows you to control the timing of any waiting that happens. However, unless there are a large number of cells and multiple workbooks involved, it should not take that long... If you need further help, just let me know. Thanks for rating FixYa!
Posted on Apr 29, 2008
SOURCE: Excel password
You can not do this by making changes in the registry. Do a google search on "Hacking Excel 2003 Passwords" and you will find dozens of free downloads to delete the passwords on excel files. Some of the better ones are John the Ripper, PWDump, and Cain.
Posted on Dec 12, 2008
here is the solution ifi Excel opens without opening any file after double clicking on the excel file,
1. Tools>Options>General uncheck "Ignore other Applications"
2. Exit Excel and try again
If this doesn't work try to re-register Excel
1. Close Excel first and On the Windows Taskbar
2. Start>Run "excel.exe /unregserver"(no quotes)>OK.
3. Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
if there is anyother issue in which may i help u then feel free to contact me
Posted on Dec 16, 2009
Tips for a great answer:
Feb 22, 2011 | Computers & Internet
on May 16, 2010 | Computers & Internet
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Feb 21, 2011 | Computers & Internet
Feb 09, 2011 | Microsoft Office Professional 2007 Full...
Jul 11, 2009 | Microsoft Computers & Internet
Jan 03, 2008 | Computers & Internet
Aug 23, 2017 | Excel Computers & Internet
45 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: