Description:
Microsoft Office Excel newsgroup.
|
|
|
L2013 not running code from XL7, second posting
|
| |
I have a worksheet with VBA code that has been in use for at least 12 years. It still works flawlessly in XL7 (2007). The code opens a folder which contains 24 photos (5M each) and places them in a worksheet along with their file name and date. The code even fails when I step thru the code, but seems... more »
|
|
|
XL2007 code not working in XL2103
|
| |
I have been using a VBA module for several years in XL 7 but crashes in 2013. Even when I step thru the code, it will crash about 50% of the way. The code basically inserts 24 photos into a spreadsheet for printing. It also includes date and photo ID. The code is attached. Please, any advice??... more »
|
|
|
Make peak values move to low value region - Peak Lopping - HELP!
|
| |
Hi guys,
I am trying to create a spreadsheet of daily energy use and have the
ability to shift the max values to a period when the values are lower.
Effectively I want to shift the peaks to trough regions. The spreadsheet
will be used to model an energy usage profile by shifting the peaks to a... more »
|
|
|
Scientific Notation
|
| |
Hello
I am stuck in a wierd situation. I have a data, with which I creates a
Pivot. Some of the value coming in Pivot are Zero, however some of those
Zeros are though displayed as Zero, but when I press F2 to go into that
cell they have values like 4,54747350886464E-13 or 2,27373675443232E-13.... more »
|
|
|
prevent deletion of a workbook in a shared network drive
|
| |
My company saves 2010 excel workbooks in a shared network drive. The
problem is that everyone has access to them so sometimes they are
mistakenly deleted. Is there a way to protect the 2010 excel workbooks
so that they can not be deleted from the shared network drive?
-- ivana
|
|
|
IF statement help
|
| |
Good Morning/Afternoon,
Was hoping for help with a complicated (to me!) excel issue. Seen others
use animals to try and explain there issues so will do the same, hope it
doesn't come off as patronising!
Basically I have reports sent to me with data, but if there is 0
quantity for an item it will not show up on the report.... more »
|
|
|
Separting negative numbers from letters in cells
|
| |
Okay I had to code data and possible values were as follows:
-2c
-2b
-2a
99
1a
1b
2
I accidently put them all in the same cell however I need the letters
and numbers in different cells (for example given |-2c| I would want to
output |-2|c| with the straight lines being cells). I know there were... more »
|
|
|
Randomizer
|
| |
I have been asked by my work to create a Lunch Buddy Program. I will
need to enter employee names into a list and then have a randomizer
select two people at a time until all names have been selected. Has
anyone ever done this in Excel? If yes, could you explain how I would
do this.
thanks... more »
|
|
|
CountIf from multiple sheets in another workbook
|
| |
i have 1 workbook with about 20 sheets, i need to search this workbook
for a name in one column on each sheet. i made a list of the sheets in
the 2nd workbook in column a. i tried this formula in column b, but i
can't get it to recognize the cell in my formula:
=SUM(SUMIF(INDIRECT("'[cfshows .xls]&A2'!U:U"),"Brown, Bob"))... more »
|
|
|
