Question about Excel Computers & Internet

1 Answer

I have never used excel before in my new job I have been told to send aprils daily banking sheets in a file to head office I have no idea what to do please help

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Top Expert:

    An expert who has finished #1 on the weekly Top 10 Fixya Experts Leaderboard.

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

  • Excel Master
  • 76,673 Answers

Posted on Jun 26, 2017

Ad

6 Suggested Answers

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

Ad
  • 214 Answers

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:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Posted on Apr 08, 2008

  • 359 Answers

SOURCE: OFFICE XP EXCEL SHEET OPEN VERY SLOW PROBLEM

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 locks file when using data connection to other sheet.

excel formula

Posted on Oct 19, 2008

  • 23 Answers

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

  • 1 Answer

SOURCE: microsoft excel file dose not open autometically

hi Friends

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
kamal_lalwani@dell.com
kamal0806us@yahoo.com
+9742128873 /

Posted on Dec 16, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Computers & Internet

Tip

What is Packed.Mystic!gen5 virus and how to remove it


For remove Packed.Mystic!gen5 virus,please clean/delete all Packed.Mystic!gen5 infected files and Delete/Modify any values Packed.Mystic!gen5 added to the registry as following:
SUMMARYTECHNICAL DETAILSREMOVAL.
This virus is first detected: April 28, 2010
Updated: April 28, 2010 8:11:01 AM
Type: TrojanSystems
Affected: Windows 2000, Windows 95, Windows 98, Windows Me, Windows NT, Windows Server 2003, Windows Vista, Windows XP
Packed.Mystic!gen5 is a heuristic detection for files that may have been obfuscated or encrypted in order to conceal themselves from antivirus software. It is used to detect threats associated with the trojan.FakeAV family.For more information, please see the following resource:
trojan.FakeAVAntivirus. This virus /Worm/Torjan self protect for the following Dates. Initial Rapid Release version April 28, 2010 revision 003. Latest Rapid Release version April 28, 2010 revision 003Initial Daily Certified version April 28, 2010 revision 021 Latest Daily Certified version April 28, 2010 revision 021Initial Weekly Certified release date April 28, 2010A trojan horse that opens a back door on the compromised computer that modifies the home page and desktop settings on a compromised computer.,ADware can also slow your Internet connection by using bandwidth to retrieve advertisements. In addition, adware can increase the instability of your system because many adware applications are not programmed well.it can automatically plays, displays, or downloads advertisements to a computer after the adware software is installed.steals information such as bank accounts, usernames, passwords and credit card details from your computer and sends it to the attacker. here for a more detailed description of Rapid Release and Daily Certified virus definitions.This virus/maleware/sapm/Worm threat report:SUMMARY detect level of this level SUMMARY detect level of this level
Level: LowNumber of Infections: 0 – 49
For successful remove Packed.Mystic!gen5 virus,you may also need do as following:
1. Temporarily Disable System Restore .
2. Update the virus definitions. Reboot computer in SafeMode;
3. Delete the IE temp files,some Packed.Mystic!gen5 temp file exisit there.
Read more information at flowing links:

PC solutions

What is Packed.Mystic!gen5 virus and how to remove it

on May 16, 2010 | Computers & Internet

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

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.

Excel Template

.xltx

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).

Excel Macro-Enabled Template

.xltm

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.

Excel Add-In

.xlam

A supplemental 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 sheets.

Feb 21, 2011 | Computers & Internet

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...

1 Answer

Forget the password for the excel sheet


I assume that its a very important file. There are a lot of utilities that allow you to retrieve the password from Microsoft Office files. One that I would recommend based on my personal experience is "Advanced Office Password Recovery" a.k.a. AOPR. I have used the program and its amazing, especially with Excel as you dont have to use Brute Force (mumbo jumbo in password retrieval world) to retrieve the password.

Jul 11, 2009 | Microsoft Computers & Internet

2 Answers

Excel oquestion


how to remove the excel file security pass word


solution explain tel plz

Feb 09, 2009 | Microsoft Office Excel 2003 for PC

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Export data in excel shld yoeet through VB


When i first figured out how to pull data from SQL and put the results in an excel file i referenced these two articles....
Reading and writing excel file using VB.NET (http://www.codeproject.com/KB/vb/Work_with_Excel__VBNET_.aspx)
Get the Values From DataBase and Stored into excell Sheet (http://www.codeproject.com/KB/vb/Getvaluesfromdatabase.aspx)

This is the code i ended up using.... (check out those links to see how you need to import the ms office excel reference file with visual basic)

Const stcon As String = "Provider=SQLNCLI;server=xxxxx;database=xxxxx;uid=xxxxx;pwd=xxxxx;DataTypeCompatibility=80"
Dim stSQL As String = "select * from scs_rate_class_money where irate_book = 124 and snew_used = 'U' and sclass = '2' and splan = 'T4' and sopt_code = 'F1'"
Dim cnt As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim fld As ADODB.Field
'Open the connection.
cnt.Open(stcon)

'Open the recordset.
With rst
.CursorLocation = ADODB.CursorLocationEnum.adUseClient
.Open(stSQL, cnt, ADODB.CursorTypeEnum.adOpenForwardOnly, _
ADODB.LockTypeEnum.adLockReadOnly , _
ADODB.CommandTypeEnum.adCmdText)
.ActiveConnection = Nothing 'Disconnect the Recordset.
End With
'Close the connection
cnt.Close ()
Dim exp As Export = New Export()
Dim xlApp As New Microsoft.Office.Interop.Excel.Application
Dim xlWBook As Microsoft.Office.Interop.Excel.Workbook = xlApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet )
Dim xlWSheet As Microsoft.Office.Interop.Excel.Worksheet = CType(xlWBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet)
Dim xlRange As Microsoft.Office.Interop.Excel.Range = CType(xlWSheet, Microsoft.Office.Interop.Excel.Worksheet).Range("A2")
Dim xlCalc As Microsoft.Office.Interop.Excel.XlCalculation
Dim i As Short

'Turn off Excel's calculation.
With xlApp
xlCalc = .Calculation
.Calculation = Microsoft.Office.Interop.Excel.XlCalculation.xlCalculationManual
End With
'Write the fieldnames.
For Each fld In rst.Fields
xlRange.Offset(0, i).Value = fld.Name
i = i + 1
Next
'Populate the range.
xlRange.Offset(1, 0).CopyFromRecordset(rst)
'Close the recordset.
rst.Close()
'Make Excel available to the user.
With xlApp
.Visible = True
.UserControl = True
'Restore the calculation mode.
.Calculation = xlCalc
End With
'Release variables from memory.
fld = Nothing
rst = Nothing
cnt = Nothing
xlRange = Nothing
xlWSheet = Nothing
xlWBook = Nothing
xlApp = Nothing

Jan 03, 2008 | Computers & Internet

1 Answer

Creating a report


I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2) whenever you update sheet one cell C5 it will automatically appear in new sheet...

Aug 29, 2007 | Microsoft Office Standard for PC

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

Related Topics:

45 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

yadayada
yadayada

Level 3 Expert

76673 Answers

gary433

Level 2 Expert

237 Answers

john h

Level 3 Expert

12650 Answers

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

Answer questions

Manuals & User Guides

Loading...