We have a file in csv format with about 1200 columns and over 2 million rows. It is 3.8 gb and too large to open in Excel. We need to be able to filter on several columns at once to conduct specific searches and are stymied trying to find something that will work. Any suggestions?
That was very helpful. I did misunderstand that. Still think I am missing something.
In step 4 there is a question "How many page fields do you want?" which defaults to "0" and I didn't change that. There are options to choose the item labels but when leaving page fields as zero there is no...
To Skip,
I entered everything exactly as you had it in your file to Normalize, etc. but it didn't sum they way yours did. I can't see where ZI am making any mistake but who knows. I am at a loss to explain it.
I have replicated what you did but it is still not working for me. I can't post my actual file publicly as it is private company financial information. Is there a way to circumvent this?
Thanks. I didn't get very far trying to recreate this. I am using Excel 2016, and my option for a Pivot Table is thru Insert/Pivot Table but there is no option for "Multiple Consolidation Ranges". It only asks to Select a table or range, then choose where it is to be placed. I see no option to...
See the attached file. The goal is sum the amounts in the Income tab in the cell in the Budget tab for each Income type. http://files.engineering.com/getfile.aspx?folder=545ea17e-15da-4548-a904-7664e029b0e5&file=Budget_2018_Worksheet_Tek_Tips_Help.xlsx
I have a spreadsheet I am trying to build as template for a budget. In one tab I have listed all our customers and the budgeted amount of income per month. Included in that tab is a column showing the type of income for each client (which income account) by month, it could be one of 6 different...
This has gotten especially bad since we started using Google Apps and hosted our email on Google. Email replies from some companies do not get coded properly or something and do not show up in Outlook. The header shows receiving the email from the proper party but nothing shows in the text. If I...
POP3. I use Google Apps For My Domain but have it set up per their instructions. It has worked fine in the past, just suddenly started this issue of not sending.
I'm perplexed. Suddenly my Outlook 2003 won't send my email. I receive everything fine. When it attempts to send it just acts like nothing is in the Outbox, but there are currently 11 emails in my outbox.
I want to wipe my drive clean so I can reinstall windows and start over with a new (ie unclutered and faster) drive. If I just reinstall Windows it won't wipe anything off.
I want to format my hard drive on my laptop. I don't need most of the programs or files and have copied anything I need. I primarily use it only to surf the web or to connect to my pc at work using logmein.com. I open My Computer and click on the "C" drive, than go to File\Format. It keeps...
I would accept that if it wasn't also several others and if I didn't have this problem when sending from my Mac. I only included cebridge and Alltel in my question, but my email also had the same rejection from Netscape, Hotmail and SBCGlobal.
Using Outlook 2003. For some reason I frequently get the following error message when I attempt to reply to an email.
Your message did not reach some or all of the intended recipients.
The following recipient(s) could not be reached:
'abc@cebridge.net' on 6/30/2006 7:59 AM...
Using Outlook 2003. I accidentally deleted an entire Distribution Group when I meant only to remove one member. Clicked in the wrong place. I don't see the deleted group in my Recycle Bin. I had several hundred members and recreating it will be a major pain. Am I stuck or is there a way to find it?
Using Outlook 2003 with Business Contacts Manager. Whenever I compose a new email and click"To" to select a name, it automatically opens to "Accounts" list on the drop down instead of to Contacts, which is where I have most of the contacts. Is there a way to make the default open to Contacts...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.