I work a lot with macros. The computer I am using will not store macros or save alterations to the style sheet (normal). I have tried uninstalling and reinstalling the software. I have also tried buying Office 2012 (at an extortionate price), but both solutions have not worked. My computer uses (x86), whatever that means, and I think that this is probably linked to the problem, as the old version (Office XP) worked on my other computer, but not on this one. Can you help me please, as I do not seem to be able to get any help from Microsoft websites. Kind regards Kaye Hill
Hello there
try this! and hope it will help!
SOURCE: Office 2007 Standard - VBA not working
There is no indication that VBA should not work in all versions of Excel. There is a new file extension (xlsm), which is used to activate macros and allow usage. If you have, perhaps, opened and saved with incorrect extension (new is xlsx), VBA may be unavailable. Try to resave it with the changed extension. It seems likely that this is the issue (reference http://office.microsoft.com/en-us/excel/HP100141031033.aspx?pid=CH100648071033). Also, if you make sure your Save As option is set at xlsm, this should help to prevent problems. VBA should not be an issue in any version of Excel and custom functions ARE available (see http://office.microsoft.com/en-us/excel/HA102189961033.aspx?pid=CH100645021033). It should be as simple as changing the extension, and I would suggest changing the default save as option. If this helps, please rate "FixYa"! Thanks!
SOURCE: OFFICE XP EXCEL SHEET OPEN VERY SLOW PROBLEM
If you have linked one workbook to only one other workbook, I would suggest opening both. This should cause the main one to update basically instantly, and eliminate the timing issue. Otherwise, you might try looking at possibly storing both files in the same folder - it could help. Additionally, depending on what you want the sheet to do, you could set it to update only when you tell it to, rather than automatically - this allows you to control the timing of any waiting that happens. However, unless there are a large number of cells and multiple workbooks involved, it should not take that long... If you need further help, just let me know. Thanks for rating FixYa!
SOURCE: microsoft word will not respond
close office, delete normal.dot then reopen. That should fix it
SOURCE: "Not enough memory to run microsoft excel."
it is conflicy with win xp updates.
check your ram.
go to device amanger then advanceced increase your virual memory to 1.5 *your rammmeory.
SOURCE: I need a product key for microsoft office 2003 for Windows XP
if you have the Disc contact Microsoft at 1-800-936-5700
Excel Workbook
.xlsx
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Excel Macro-Enabled
Workbook
.xlsm
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
Excel Template
.xltx
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Excel Macro-Enabled
Template
.xltm
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
Excel Add-In
.xlam
A supplemental
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
sheets.
115 views
Usually answered in minutes!
×