A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Lost password for password protected Excel file by R
I have an Excel file in .xls format last saved in Excel 2016 which is password protected that I need to open. Would anyone be able advise of an application...
April 29th 17 01:17 PM
by GS[_6_] Go to last post
1 57
11 3,183
In excel 2000, IF function calculates incorrectly using "E" by [email protected]
Using E for zero. =IF(C2="E",(O2),(O2)) does not calculate correctly. Substituting a zero, formula will work OK. Using #'s all is OK. Can I write a formula...
April 28th 17 07:55 PM
by GS[_6_] Go to last post
1 25
Need a pivot table subset of a pivot table (slicer doesn't work) by Phrank
Hi, I know there is a plethora of pivot table and index/match posts, and I feel I've gotten close to resolving my issue, but no dice so far. I've got a...
April 28th 17 07:50 PM
by GS[_6_] Go to last post
3 31
1 Attachment(s) Stack bar chart configuration in Excel by volabos
Hi, I have created a stack bar chart pair, as in the attached Workbook. Now I want to reduce the gap/distance between 2 columns, i.e. want to make 2 bars...
April 27th 17 06:17 PM
by volabos Go to last post
0 36
Excel should let me create pivot tables of non-numeric data. by Geek4Life
Basically, the need is to build multi-dimensional tables of text. This would be more ideal in Word, but Excel PivotTables comes so close...if only it...
April 25th 17 11:07 PM
by GS[_6_] Go to last post
4 879
Crystal Reports export to Excel - Loss of Leading Zeros by [email protected]
On Monday, November 1, 2004 at 11:48:04 AM UTC-4, CR-Tech wrote: > Crystal Enterprise is the web-based front-end server which displays > stored/linked Crystal...
April 25th 17 07:16 PM
by GS[_6_] Go to last post
1 52
break links not working by swoxo
In Excel 2007, I have a workbook with one link that I want to break. In the Ribbon, I go to the Data tab, and in the Connections section I choose Edit...
(Multi-page thread 1 2 3 ... Last Page)
41 12,574
Advanced filter using dates by Rusty
I have a column formatted as a date field and need to do advanced filtering on it. For example, I want to filter out entries between two dates. When I build...
April 20th 17 05:11 PM
by excel_vba Go to last post
3 2,496
how can i get the labour market economics 7th edition test bank? by [email protected]
how can i get the labour market economics 7th edition test bank?
9 1,948
Copying a worksheet - won't work help please by [email protected]
On Sunday, March 5, 2000 at 11:00:00 AM UTC+3, Ber Visser wrote: > The easiest way to copy a worksheet is to select its tab and, whilst > pressing Ctrl and the...
April 18th 17 06:38 PM
by Dave H Go to last post
1 162
Can I keep external connections in a table? by Dave H
Currently I have worksheet that pulls in a query from an external source. Then I have another worksheet that references the external query, this sheet is...
April 18th 17 02:59 PM
by Dave H Go to last post
0 64
Can I arrange tabs vertically in Excel (not horizontally)? by LinLin
I use a lot of tabs / worksheets in a spreadsheets and if I could view them vertically (ie on the RHS of the screen) I could fit more tabs in! Is there...
(Multi-page thread 1 2)
13 2,125
Can you print multiple worksheets double sided? by Publisher Lyn
We publish an annual publication of detailed tables. Each section of the book is created in a single Excel workbook - each page of the book is one Excel...
(Multi-page thread 1 2)
April 9th 17 03:09 AM
by cacuoc334465c Go to last post
16 4,487
Hi all, How do I ask Excel to stop "rounding"? I know Round up and down functions however I want excel to stop "rounding" and do not take into account the...
April 5th 17 10:20 AM
by pedro Go to last post
1 244
how to unhide multiple rows in one go? by Satnam Randhawa
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do I unhide all the rows in one work sheet in one go without having to drag them...
(Multi-page thread 1 2 3 ... Last Page)
41 13,229
File Path Too Long? Not Anymore! Check out Long Path Tool by Max Loger
http://LongPathTool.com Long Path Tool recognizes the processes or running programs which have locked those files, preventing them from being renamed, moved...
March 24th 17 07:59 AM
by liona1982 Go to last post
1 989
words in cell keep repeating by Hyde Park
In a worksheet that has been created and that we used repeatedly in our business, one cell keeps repeating the name we are placing in it. Such as we type...
7 2,287
Adding the same field in the column field list of pivot table by nanka
Hi, I am showing the %row total of certain categories per week in the pivot table. The source is a query table. When i am clicking insert I create the pivot...
March 19th 17 03:17 AM
by nanka Go to last post
0 212
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, June 17, 2010 at 9:50:35 AM UTC+5:30, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error :...
0 207
Post New Thread

Display Options
Showing threads 1 to 20 of 146455
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.