I have been asked to get a spreadsheet that is used for planning in our business to open in excel viewer. I have had problems with this as when open it immediately closes. I think this is due to the VBA and macros that are running within it. Are there any ways to work round this or is it a case of buying a full copy of excel is the only way to do this ?

I went into the trust center on a computer with a full copy of excel and disabled macros saved it then opened on the viewer pc and it opened. Don't understand why they have to be manually turned off to make it work.

Ok just ran all of the windows updates and it works regardless of what setting is set for macros. Must have been something microsoft fixed. Never mind first time for everything I suppose. Thanks for your help and support.