Search results for query: *

I have had this problem before and there was some issue around autosizing the columns. Try setting the columns to a fixed width like 17, then save the file and re-open. If this works, she may have been using the autofit feature and there was something funny going on...for lack of a better...

If you are using Excel 2000, it is very easy. For each spreadsheet you need to open it up and go into edit>links...and then hit change source and point that set of links to the new source. This should work.

Up to Office Excel, I know that I can not be done. The only work around that I have come across is to set the header and titles both to 0 and put the logo on the sheet with what you would have used as header text next to the logo.

I am trying to create column and row reports in MS Excel by calling data from the cube and populating the spreadsheet and I am looking for the best way to this (beyond brining a pivot table back from the cube). I want to create a custom function in Excel and then call the cube, but I do not...

I have built a model to perform what if analysis of about 150 different scenarios with ~20 varibles that change. I want the model to cycle through my scenario, copy and paste the output to a spreadsheet, reset itself and go to the next scenario, repeating until it gets to the final scenario...