Excel Tips - Fix Corrupt Spreadsheet

Here's a few web links to some useful information:

An Introduction to Spreadsheets

Jan's Excel Spreadsheet Design

Overview of Spreadsheets

If you have more, please add to this list.

42!

Hi,

I have a spreadsheet that appears corrupt - every time I open it Excel
crashes. Does anyone have any ideas on what I can do with a suspect corrup
spreadsheet file?
--
Many thanks in advance for any assistance

From a simple excel export I have historical prices for the S&P 500 dating back to eternity (open, high, low, close). I first need an additional column with the 50 day moving average values. Any ideas on how to setup this formula?

Now the hard part...

Once I have the 50 day ma's I need additional columns stating the values in terms of standard deviations in relation to the 50 dma.

Lastly, if possible, I need a nice graph as well.

No sweat right? Lol... Thanks for any advice...

Morning all,
I have searched for an answer before posting this thread, so apologies if this has already been covered.

I am an average user of Excel 2003 to manage a 1.7mb shared workbook, from which 40+ users input data. I have 3 main serious problems:

1) Although shared, occaisionally I get the message " the file is locked by USER, please save with different file name

2) At least twice a week, my workbook becomes corrupt and a series of weird files appear next to the Original file. These files have no extension, no description, they look like temporary files, but do not delete themselves, always 8 characters in length, a mix of numbers and letters.

I delete these files when they appear, remove the sharing, save the file, then share it again to prevent corruption, but 2 days later, same happens again. I am unable to open the original spreadsheet, but if I click on one of these weird files, it opens up to my workbook????

3)when I remove sharing, a number of users appear in the list, but are not actually in the file. Or the same name will appear twice with different dates.

I appreciate any thoughts you may have with these issues.

Many Thanks

Jet-Leon

Hello,

I'm working with a fairly large spreadsheet involving many calculations and was wondering if someone could give me some tips on designing worksheets to minimimize calculation times.

I'm using Excel 2007. I believe that in previous versions of Excel, calculation times were slower if calculations used data on cells from different worksheets. I also think that calculation times were lengthened by using 'IF' formulae rather than 'OFFSET'.

Could someone tell me if the old rules for improving calculation speeds in previous versions of Excel still apply to Excel 2007?

Also, I'd like help with the following specific cases:
-I need to run calculations using two grids of data. Each grid contains approximately 40,000 rows and 2,000 columns of data. Would the calculations using data from both of these grids be faster if they were on the same worksheet than if they were on separate worksheets?

-In general, is it faster to have calculations split up over multiple worksheets than entirely on one worksheet?

If anyone has a link they can send me that addresses these general questions it would be much appreciated!

Thanks in advance!
Derek

Hi all,

I often have to deal with spreadsheets with 20,000+ rows of data in it with a lot of formulas which makes the size of my spreadsheet really large and hence it takes a long time to process anything and often crashes when I try to do something simple like insert a column - does anyone have tips to help to deal with this when working with such huge amounts of data?

Just to note, I have excel 2007 which is great and I believe has even more rows and columns but I find I can't handle 20,000 rows so how do others who have this situation deal with it?

Many thanks, I really appreciate any tips.

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub